mysql - 按案例订购

Question

这是一个有效的SQL语句吗

select title
from table
order by case when title like "%string%" then 0 else 1 end asc

如果我使用 title = "string" 我会得到有效的结果。我怎样才能改变它以便它接受 %string%

Answer 1

select title
from table
order by case when title regexp "string" then 0 else 1 end asc;

I am not putting it as ^string because you were searching for %string%.