摘要:
in可以在where后规定多个值 SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...) BETWEEN ... AND 会选取介于两个值之间的数据范围。这些值可以是数值、文本或者日期 SELECT 阅读全文
摘要:
SELECT * FROM student WHERE SNAME LIKE '王%' SELECT * FROM student WHERE SNAME not LIKE '王%' SELECT * FROM student WHERE SNAME not LIKE '%小%' #名字不叫X小X 阅读全文