21,887
社区成员
发帖
与我相关
我的任务
分享
select title, word, count(*) as cnt
from (
select title, '高级' as word from tbl_name title like '%高级%'
union all
select title, 'PHP' as word from tbl_name title like '%PHP%'
union all
select title, '教程' as word from tbl_name title like '%教程%'
) T
order by count(*) desc