语法顺序:
select
from
where
order by
limit
-------------------------------------
IN
WHERE state IN ('va', 'fl', 'ga')
BETWEEN
WHERE points BETWEEN 1000 AND 3000
LIKE
%
任何个数(包括0个)的字符(用的更多)_
单个字符
WHERE last_name like 'brush%'
REGEXP
符号 | 意义 |
---|---|
^ | 开头 |
$ | 结尾 |
[abc] | 含abc |
[a-c] | 含a到c |
| | logical or |
where last_name regexp 'field'
IS NULL
where phone is null/is not null
ORDER BY
order by new_price desc, product_id
LIMIT
limit 3
limit 6, 3
6, 3 表示跳过前6个之后,再取3个