SQL数据过滤

SELECT name, hp_max FROM heros WHERE hp_max > 6000
SELECT name, hp_max FROM heros WHERE hp_max BETWEEN 5399 AND 6811
SELECT name, hp_max FROM heros WHERE hp_max IS NULL

SELECT name, hp_max, mp_max FROM heros WHERE hp_max > 6000 AND mp_max > 1700 ORDER BY (hp_max+mp_max) DESC
-- 一般来说 () 优先级最高，其次优先级是 AND，然后是 OR。
SELECT name, hp_max, mp_max FROM heros WHERE (hp_max+mp_max) > 8000 OR hp_max > 6000 AND mp_max > 1700 ORDER BY (hp_max+mp_max) DESC

SELECT NAME,ROLE_MAIN,ROLE_ASSIST,HP_MAX,MP_MAX,BIRTHDATE FROM HEROS WHERE (ROLE_MAIN IN ('法师', '射手') OR role_assist IN ('法师', '射手')) AND DATE(birthdate) NOT BETWEEN '2016-01-01' AND '2017-01-01' ORDER BY (HP_MAX+MP_MAX) DESC

SELECT NAME FROM HEROS WHERE NAME LIKE '%太%'
-- （_）只代表一个字符 （%）代表一个或多个字符
-- 太不是在第一个字符
SELECT NAME FROM HEROS WHERE NAME LIKE '_%太%'