mysql 查询语句

• 条件查询
  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#