Menu
Community /Pin to ProfileBookmark
@NogDogOct 15.2021 — #Only way that pops to mind is to add an additional
@NogDogOct 15.2021 — #@boohoo#1638202 Cool, just tried (something like) it in PostgreSQL to confirm it supports that sort of thing, too:
MySQL Order By specific string then alphabetically
Is it possible to order by a specific string then alphabetically?
For example, I want to show all the SMITHS first then ‘ORDER BY `userName
I don’t believe it is, but I welcome any ideas.
Sign in
to post a comment3 Comments(s) ↴
0
@NogDogOct 15.2021 — #Only way that pops to mind is to add an additional case[code=sql]
select
*, -- or list specific columns you want
case
when last_name = 'SMITH' then 0 -- adjust upper-/lower-case as needed
else 1
end as name_sort
from the_table
order by name_sort, last_name, first_name
[/code]0
@NogDogOct 15.2021 — #[code=sql]
select predicate_type_id
from some_schema.predicate_type
order by mod(predicate_type_id, 2), predicate_type_id
[/code][code=text]
OUTPUT:
4
6
8
10
12
14
16
1
7
9
11
13
15
17
[/code]