MySQL WHERE条件 模糊查询

WHERE

比较 

=, <, <=, >, >=, !=, <>, !>, !< ,<=>

注意 <=> 可以比较NULL, =不能

指定范围

BETWEEN AND, NOT BETWEEN AND

指定集合

IN, NOT IN

匹配字符

LIKE, NOT LIKE

是否为空

IS NULL, IS NOT NULL

多个条件

AND, OR

----------------------------------------------

例子

SELECT * FROM user WHERE id BETWEEN  22 AND 35;

SELECT * FROM user WHERE id IN(22,23,24);

模糊查询

% 代表0个或多个任意字符

_代表1个任意字符

SELECT * FROM user WHERE name LIKE  'KY%'; #以KY开始的名字

SELECT * FROM user WHERE name LIKE  '____'; #名字四位的