基本keyword in SQL

%

字符的任意组合

 

_

任何单个字符。 where title like '_ales'

 

[]

[a-d]范围或者[abcd]字符集内的单个字符。where title like '[bs]ales'表示选择title列等于bales或者sales的所有行

 

[^]

不在[^a-d]范围或者[^abcd]字符集中的单个字符

 

IS NULL

where region is null表示返回region列未设置值的行

 

IS NOT NULL

where region is not null语句表示返货所有region已经设置值的行

 

between

where extension between 400 and 500 。 返回extension值在400~500之间的行

 

in

where city in ('seattle','london')。 

 

and

where (title like 'Sales%' and lastname='Peacock')

 

not

where not (title like 'Sales%' and lastname='Peacock')

 

or

where (title like 'Sales%' or lastname='Peacock')