它可能是解决方案之一：
SELECT id, desc, abbreviation, etc FROM
(
SELECT 1 AS rnk, id, title as 'desc' , abbreviation , etc FROM shows
WHERE abbreviation LIKE '%".$term."%'
UNION
SELECT 2 AS rnk, id, title as 'desc' , abbreviation , etc FROM shows
WHERE title LIKE '%".$term."%'
) tab
ORDER BY rnk
LIMIT 10;
或者您可以通过以下方法实现相同目的：
SELECT id, desc, abbreviation, etc FROM
(
SELECT CASE WHEN abbreviation LIKE '%".$term."%' THEN 1 ELSE 2 END As rnk,
id, title AS desc, abbreviation, etc
FROM shows
WHERE abbreviation LIKE '%".$term."%'
OR title LIKE '%".$term."%'
) tab
ORDER BY rnk
LIMIT 10;
602392714
清零编程群