SELECT *
FROM tt
WHERE keyword LIKE '%电脑%'ORDER BY case keyword when '电脑' then 0 else 1 end,
case keyword when '电脑' then sort end desc
FROM tt
WHERE keyword LIKE '%电脑%'ORDER BY case keyword when '电脑' then 0 else 1 end,
case keyword when '电脑' then sort end desc
ORDER BY case when keyword='电脑' then sort else 999999999 end DESC
SELECT * FROM tt WHERE keyword LIKE '%电脑%'
ORDER BY case when keyword='电脑' then -sort else 999999999 end
努力学习SQL ing...