MySQL中的SQL排序

 select * from users where...

 1. where description = \"query\"

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

 3. where description = \"q1\" or description = \"q2\"

 4. where description = \"%q1%\" or description = \"%q2%\"

SELECT   1 as OrderBy, *
FROM     users
WHERE    description = \"query\"
UNION ALL
SELECT   2 as OrderBy, *
FROM     users
WHERE    description = \"%query%\"
...
ORDER BY
         OrderBy

select * from users 
where description like \"%query%\" 
  or description like \"%q1%\" 
  or description like \"%q2%\"