Mysql语句where中设置多个查询条件
SELECT * FROM `student` WHERE 1 = 1 AND `sex` = 1 AND `stu_no` IN ('STU25110004') AND (`remark` IS NULL or `remark` = '' ) ORDER BY `id` DESC LIMIT 20
对remark字段查询多个或条件
SELECT * FROM `student` WHERE 1 = 1 AND `sex` = 1 AND `stu_no` IN ('STU25110004') AND (`remark` IS NULL or `remark` = '' ) ORDER BY `id` DESC LIMIT 20
对remark字段查询多个或条件