mysql选择第一条记录[关闭]

+----+---------+
| id | name    |
+----+---------+
|  1 | David   |
|  2 | Roz     |
|  3 | Patrick |
|  4 | Chris   |
|  5 | Agnes   |
|  6 | Freya   |
+----+---------+

How result first record my option.
example: I choose roz is first

+----+---------+
| id | name    |
+----+---------+
|  2 | Roz     |
|  1 | David   |
|  3 | Patrick |
|  4 | Chris   |
|  5 | Agnes   |
|  6 | Freya   |
+----+---------+

or I choose first agnes

+----+---------+
| id | name    |
+----+---------+
|  5 | Agnes   |
|  1 | David   |
|  2 | Roz     |
|  3 | Patrick |
|  4 | Chris   |
|  6 | Freya   |
+----+---------+

something like this, your specific name, then the default sort for the rest

SELECT *
FROM `FOO`
ORDER BY (`name` = 'Roz') DESC, `name`