594
社区成员
发帖
与我相关
我的任务
分享
select * from pages where url like '%test%' or body like '%test%' or site like '%test%'
order by case
when url like '%test%' then 0
when body like '%test%' then 1
when site like '%test%' then 2 end
select p.id,p.url,p.title,p.body,p.site from pages p
where p.url like '%test%'
or p.body like '%test%'
or p.site like '%test%'
order by length(p.url) desc
;
(select id,url,title,body,site from pages where url like '%test%') union all
(select id,url,title,body,site from pages where url not like '%test%' and body like '%test%') union all (select id,url,title,body,site from pages where url not like '%test%' and body not like '%test%' and site like '%test%')