select * from table
where
title like ‘%title1%’ or title like ‘%title2%’
order by
((case when title like ‘%title1%’ then 1 else 0 end)+(case when title like ‘%title2%’ then 1 else 0 end)) desc
limit 10
select * from table
where
title like ‘%title1%’ or title like ‘%title2%’
order by
((case when title like ‘%title1%’ then 1 else 0 end)+(case when title like ‘%title2%’ then 1 else 0 end)) desc
limit 10