select * from #A order by (case charindex('西瓜',text_field) when 0 then 0 else 1 end)
+(case charindex('土豆',text_field) when 0 then 0 else 1 end)
+(case charindex('青椒',text_field) when 0 then 0 else 1 end) desc
解决模糊查询的结果记录排序问题
最新推荐文章于 2022-11-27 17:11:07 发布