-- 1
select * from book ;
-- 2
select *,(
case id when '2' then '二'
else '保密' end) as number
from book ;
-- 3
select *,(
case id when '%2%' then '二' -- 只能使用== 不能使用like
else '保密' end) as number
from book ;
-------------------------------------------------------------
-- 4
select *,(case when id = 2 then '二'
when id = 3 then '三'
when id like '%4%' then '四' -- == 和 like均能使用
when id like '%5%' then '五'
when id like '%6%' then '六'
else '未知' end
) as number
from book;
-- 5
select *,(case when id like '%2%' then '二'
when id like '%3%' then '三'
when id like '%4%' then '四'
when id like '%5%' then '五'
when id like '%6%'
mysql,case when else查询
最新推荐文章于 2025-06-17 11:49:31 发布