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字段查询多个或条件

posted on 2026-01-22 14:26  四季皆春  阅读(0)  评论(0)    收藏  举报

导航