关于mysql 指定包含条件查询
发布网友
共3个回答
热心网友
SELECT
CASE WHEN (age >=20 and age <25) THEN 0
CASE WHEN (age >=25 and age <=30) THEN 1
ELSE -1 END
FROM student
用case when
case
when 条件1 then 值1
when 条件2 then 值2
else 值3
end
热心网友
select * from student where 1=1
<if test="age == 0">
and age between 20 and 25
</if>
<if test="age == 1">
and age between 25 and 30
</if>
上面是mybatis的写法，你可以参考下
热心网友
select * from student where age between 20 and 25;
