MySQL query question

Question

I have a list of categories ordered alphabetically but I want to be able to specify a single category to be included last is it possible to do this with MySQL?

for example

current output:

a
b
c
d
e
f
g
h

desired output:

b
c
d
e
f
g
a

Current MySQL code.

 SELECT * FROM categories ORDER BY parent_id, category ASC

Mark Byers · Accepted Answer · 2010-11-24 12:34:49Z

2

You can use that 'a' = 'a' returns 1 and 'a' = 'b' returns 0:

SELECT * FROM categories ORDER BY parent_id, category = 'a', category

answered Nov 24, 2010 at 12:34

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HELP Over a year ago

is there a way I can select a certain word from a category?

Collectives™ on Stack Overflow

MySQL query question

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related