mysql 按值排序吗_如何在MySQL中按各种值排序？

例：

----------------------------------------------

P.No | Relation | Name

----------------------------------------------

2 | Self | Kumar

----------------------------------------------

1 | Husband | Selvam

----------------------------------------------

2 | Son | Manoj

----------------------------------------------

1 | Self | Gandhi

----------------------------------------------

如何基于列值首选项的行？

我想要这样的东西：

Order By P.No &

( Self 1 st preference ,

Husband 2nd preference,

son 3rd Preference )

而且我期待这个输出：

----------------------------------------------

P.No | Relation | Name

----------------------------------------------

1 | Self | Gandhi

----------------------------------------------

1 | Husband | Selvam

----------------------------------------------

2 | Self | Kumar

----------------------------------------------

2 | Son | Manoj

----------------------------------------------

请帮我解决我的问题.谢谢.