Learning SQL学习笔记3

WHERE使用：

WHERE condition1 AND condition2；

WHERE condition1 OR condition2；

WHERE expression == condition;

WHERE expression != condition;

WHERE expression BETWEEN condition1 AND condition2;

WHERE expression IN (C1, C2, ...)

WHERE expression NOT IN (C1, C2, ...)

WHERE expression LIKE conditions;

WHERE expression REGEXP conditions;

注意：

使用NULL的时候，需要用

WHERE expression IS NULL；

WHERE expression IS NOT NULL。