Want to create a custom order by using mysqli

Asked Jan 18 '18 at 04:10

Active Jan 18 '18 at 04:23

Viewed 40 times

I need to create a custom order by using mysqli conside i have a table like below

id         name

1          Della
2          Cory
3          Adams
4          Paul
5          Martin
6          Gilbert

from the above table i need to fetch Cory first and then Della,Adams,Paul,Martin and finally Gilbert how can i do that?

edited Jan 18 '18 at 04:23

asked Jan 18 '18 at 04:10

Libin Joseph

where is your code ? – Ravi Jan 18 '18 at 04:13
i think i just need the mysql orderby syntax for above table – Libin Joseph Jan 18 '18 at 04:16
if you already know, then what is your question ? – Ravi Jan 18 '18 at 04:17
why cory first? any reason? Seems like rest will come with `ASC` order apart from `cory` – Alive to die - Anant Jan 18 '18 at 04:18
Please kindly read my question again – Libin Joseph Jan 18 '18 at 04:19
@AlivetoDie its just the random data. Really i need to create a custom order by – Libin Joseph Jan 18 '18 at 04:20
what do you mean by custom order, custom is very broad term. You aren't showing what have you tried so far neither telling the logic – Ravi Jan 18 '18 at 04:21
You can try this SELECT * FROM people ORDER BY FIELD(name, 'Cory', 'Della','Adams','Paul','Martin','Gilbert'); – muttalebm Jan 18 '18 at 05:07

0 Answers0