select *
from Table_temp
order by
case
when col1='B' then 1
when col1='A' then 2
when col1='C' then 3
end desc
mysql 按字段指定值排序
最新推荐文章于 2024-04-28 15:53:20 发布
select *
from Table_temp
order by
case
when col1='B' then 1
when col1='A' then 2
when col1='C' then 3
end desc