今天接到一个需求,根据数据库中的某一个字段的值进行排序
那个字段值中有四个值,分别是:1,2,3,4
select * from tableName
where ID like '%6003%' or
KWS like '%6003%' or
ZH like '%6003%' or
TW like '%6003%' or
EN like '%6003%'
order by
case mid
when 2 then 1
when 3 then 2
when 1 then 3
when 4 then 4
end
asc
limit 100
核心代码是:
case mid
when 2 then 1
when 3 then 2
when 1 then 3
when 4 then 4
end
注意要加end