Question

php 如何查询满足任意两个条件的记录

例如，性别=‘男’ ，年龄 = ‘25’ ，爱好 = ‘篮球’ ，民族 = ‘汉’ ，国籍 = ‘中国’ 只要满足其中任意两条即可

Answer 1

可使用case when来实现这个条件，需要嵌套子查询语句

sql语句代码示例如下：
复制代码 代码如下:
SELECT * FROM DemoTable
WHERE ((SELECT CASE 1 WHEN condition1满足条件 THEN 1 ELSE 0 END FROM DemoTable )
+(SELECT CASE 1 WHEN condition2满足条件 THEN 1 ELSE 0 END FROM DemoTable)
+(SELECT CASE 1 WHEN condition3满足条件 THEN 1 ELSE 0 END FROM DemoTable)
+(SELECT CASE 1 WHEN condition4满足条件 THEN 1 ELSE 0 END FROM DemoTable)
+(SELECT CASE 1 WHEN condition5满足条件 THEN 1 ELSE 0 END FROM DemoTable))>=2
我没遇见过找的这个资料，同学习吧

Answer 2

"SELECT*FROM article WHERE num=2 && num2=1 order by teacher_num and date desc limit 0,5"

Answer 3

反对法

Answer 4

循环 in_array