Mysql：按喜欢排序吗？

order by case     when name LIKE "%John%" then 1     when name LIKE "%Doe%"  then 2     else 3 end