目录
SQL通配符【charlist】
SELECT * FROM customers WHERE `name` RLIKE '^[b]';
SELECT * FROM customers WHERE `name` RLIKE '[b]';
符号: ^ 不添加会查找所有包含b的name字段显示出来
SELECT * FROM customers WHERE id>5 ;
SELECT * FROM customers LIMIT 5; 查找前五行数据
SELECT * FROM customers WHERE name LIKE '%b%';
SELECT * FROM customers WHERE `name` LIKE 'a%';
使用通配符来查找数据,以下都可以实现
SELECT * FROM customers WHERE `name` RLIKE '^[b]';
SELECT * FROM customers WHERE `name` RLIKE '[b]';
SELECT * FROM customers WHERE regexp_like(name,'[b]'); name表示字段
SQL IN 指定多个值进行查找,可以说是or的简写
SELECT * FROM customers WHERE id IN (1,2,3,4);
SELECT * FROM customers WHERE address IN ("华山","山东");
SQL between and的用法
BETWEEN运算符用于选取介于两个值之间的数据范围内的值。
BETWEEN运算符选择给定范围内的值。值可以是数字,文本或日期。
BETWEEN运算符是包含性的:包括开始和结束值,且开始值需小于结束值。
请注意,在不同的数据库中,BETWEEN 操作符会产生不同的结果! 因此,请检查您的数据库是如何处理 BETWEEN 操作符 |
SELECT * FROM customers WHERE (id BETWEEN 2 AND 6) AND `name` NOT IN ('c');
SELECT * FROM customers WHERE (id BETWEEN 2 AND 6) AND `name`!='c';
两者运行结果相同。