-
条件查询
select * from table where uname in('aaa',bbb','ccc','ddd','eee'); -
模糊查询
select * from table where uname like aaa
select * from table where uname like '%程序员'
- 查询日期型数据 注:不同数据库对日期型数据存在差异: ：
(1)MySQL:SELECT from tb_name WHERE birthday = '2011-04-08'
(2)SQL Server:SELECT from tb_name WHERE birthday = '2011-04-08'
(3)Access:SELECT from tb_name WHERE birthday = #2011-04-08#