mysql - SQL 脚本排序

Question

我的脚本有:

  select * from users where...

where 子句将由两部分组成，它们需要按以下方式排序:

  1. where description = "query"

  2. where description = "%query%"

是否有某种方法可以将description=“query”作为1或description=“%query%”作为2并对其进行排序？

Answer 1

用途:

SELECT a.*,
       1 AS sort
  FROM USERS a
 WHERE a.description LIKE 'query'
UNION ALL
SELECT b.*,
       2 AS sort
  FROM USERS b
 WHERE b.description LIKE '%query%'
ORDER BY sort