SQL选择语句

SELECT ... FROM ...

 DISTINCT 去重

---

WHERE 子句  筛选数据

>  ; < ; <= ; >= ; != ; <>   

SELECT * FROM Customers WHERE birth_date > '1990-01-01' 

---

AND OR NOT 运算符

AND 具有优先级 

SELECT *
 FROM customers 
 WHERE birth_date > '1990-01-01' OR points > 1000 AND state='tx'  

---

 IN 运算符

同一个系列值比较一个属性

SELECT *
 FROM customers 
 WHERE state='tx' or state='ca' or state='fl';
 
 SELECT *
 FROM customers 
 WHERE state in ('tx','ca','fl') 

两个结果一样

---

BETWEEN运算符

 SELECT *
 FROM customers
 WHERE birth_date BETWEEN '1990-01-01' AND '1993-01-01';

---

LIKE运算符

"%"代表任意字符数

"_"代表一个单字符

select * from customers where address like '%trail%' or address like'%avenue%';

 select * from customers where first_name like 'i___e';

---

REGEXP运算符

^   字符串开始

$  字符串结束

|     逻辑or

[]  匹配任意在括号里举例的单字符

[a-h]  使用-代表一个范围

SELECT * FROM customers WHERE address REGEXP 'trail' 

SELECT * FROM customers WHERE address LIKE '%trail%'

两条查询结果一样

SELECT * 
FROM customers 
WHERE last_name REGEXP 'ey|on$';

SELECT * 
FROM customers 
WHERE last_name REGEXP '^my|se';

SELECT * 
FROM customers 
WHERE last_name REGEXP '^b[ru]';

---

 IS NULL 查询缺失值

---

ORDER BY子句

DESC 降序

---

LIMIT 子句

LIMIT  6，3（6是偏移量）