Amokr_的博客

SELECT * FROM customers WHERE last_name LIKE '%field%' <=> SELECT * FROM customers WHERE last_name REGEXP 'field' '^ + 字符串' ---> 限定以某字符串开头 SELECT * FROM customers WHERE last_name REGEXP '^field' ‘字符串 + $’ ---> 限定以某字符...

不管后续长度与大小写 %在左侧， 指定B或b开头的人 SELECT * FROM customers WHERE last_name LIKE 'b%' %在中间 SELECT * FROM customers WHERE last_name LIKE '%b%' %在右侧， 指定y结尾的人 SELECT * FROM customers WHERE last_name LIKE '%y' ...

BETWEEN 包含临界值 SELECT * FROM customers WHERE points >= 1000 AND points <= 3000 <=> SELECT * FROM customers WHERE points BETWEEN 1000 AND 3000

SELECT * FROM customers WHERE state = 'VA' OR state = 'GA' OR state = 'FL' <=> SELECT * FROM customers WHERE state in ('VA', 'FL', 'GA') SELECT * FROM customers WHERE state NOT IN ('VA', 'FL', 'GA') homework SELECT * FROM product...

AND SELECT * FROM Customers WHERE birth_date >= '1990-01-01' AND points > 1000 OR SELECT * FROM Customers WHERE birth_date >= '1990-01-01' OR points > 1000 SELECT * FROM Customers WHERE birth_date > '1990-01-01' OR (poi

USE sql_store; SELECT * FROM customers WHERE customer_id = 1 ORDER BY first_name -- 不区分大小写，子句换行无影响