SQL脚本排序

  select * from users where...

  1. where description = \"query\"

  2. where description = \"%query%\"

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