华佗小知识

您的当前位置：首页正文

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#