假设我有以下查询:
SELECT id, name FROM table ORDER BY name
- 4, Ashley
- 1, Anna
- 2, David
- 3, Zach
我该如何将特定的姓名排在前面,然后再对其余进行排序,类似于:
SELECT id, name FROM table ORDER BY name='david', name
- 1, David
- 4, Ashley
- 1, Anna
- 3, Zach