本文介绍了SQL查询中常用的逻辑运算符（如AND,OR,BETWEEN等）、比较运算符（>,<>,LIKE等）以及子查询的使用（EXISTS），展示了如何在数据库检索中组合这些元素以实现复杂的筛选条件。
时间：2022-09-03 20:48:53
['and', 'id=1', 'id=2'] //id=1 AND id=2
['and', 'type=1', ['or', 'id=1', 'id=2']] //type=1 AND (id=1 OR id=2)
['between', 'id', 1, 10] //id BETWEEN 1 AND 10
['not between', 'id', 1, 10] //not id BETWEEN 1 AND 10
['in', 'id', [1, 2, 3]] //id IN (1, 2, 3)
['not in', 'id', [1, 2, 3]] //not id IN (1, 2, 3)
['like', 'name', 'tester'] //name LIKE '%tester%'
['like', 'name', ['test', 'sample']] //name LIKE '%test%' AND name LIKE '%sample%'
['not like', 'name', ['or', 'test', 'sample']] //not name LIKE '%test%' OR not name LIKE '%sample%'
['like', 'name', '%tester', false] // name LIKE '%tester'
['exists','id', $userQuery] //EXISTS (sub-query) | not exists
['>', 'age', 10] //age>10
where(['<>','id',10]) //不等于
扫一扫
2527
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
