数据库数据及实现方式:
具体sql如下:
select * from test1 ORDER BY (
case when name = '张三' then 1
when name like '%张三' THEN 2
when name like '张三%' then 3
when name like '%张三%' then 4
else 5 end
);
数据库数据及实现方式:
具体sql如下:
select * from test1 ORDER BY (
case when name = '张三' then 1
when name like '%张三' THEN 2
when name like '张三%' then 3
when name like '%张三%' then 4
else 5 end
);