mysql - ORDER BY soundex 与 WHERE (MySql)

Question

查询代码:

SELECT *
FROM example
WHERE name LIKE '%test%'
OR SOUNDEX(name) LIKE 'T230%'
OR SOUNDEX(name) LIKE 'T23%'

我想首先显示与 WHERE name LIKE '%test%' 和 SOUNDEX(name) LIKE 'T230%' 匹配的结果，最后几行是SOUNDEX(name) LIKE 'T23%'

的结果

感谢您的关注。

Answer 1

您可以在order by中使用 bool 表达式。 “真”被视为“1”，假被视为“0”。所以:

ORDER BY (name LIKE '%test%') DESC,
         (SOUNDEX(name) LIKE 'T23%') DESC,
         (SOUNDEX(name) LIKE 'T230%') DESC