条件查询

1、select xxx from xxx where ...

= > < <> >= <=

and or not

2、模糊查询

LIKE

BETWEEN

IS NULL

IS NOT NULL