如何在mysql查询中将行放在顶部。

Question

Hi i have 100 records in my SQL table i want to sort them ASC by name but i need one record on top of all record nr 43.

Is there way i can pull this record 43 first and then everything else ASC order by name?

Trick is to do it in one query.

Answer 1

Use this:

ORDER BY CASE WHEN (record is 43) THEN 0 ELSE 1 END, Name