New User
joined:May 25, 2013
posts: 7
votes: 0
i have this table:
+--------+------------+
| ID | name | type
+--------+------------+
| 1 | Alex | 0
| 2 | John | 1
| 3 | Gerry | 0
| 4 | Mark | 0
| 5 | Dave | 1
| 6 | Blake | 0
+--------+------------+
how can i get an output that is ordered alphabetically, but also displaying those with TYPE==1 first?
needed output:
Dave
John
Alex
Blake
Gerry
Mark