mysql查询语句where后面加if判断 SELECT * FROM `table` WHERE IF( `parentID` =1, `plan_id` <10, `plan_id` >500 ) LIMIT 0 , 30 说明:WHERE IF(条件, true执行条件, false执行条件 )