ansaurus

Question

MySql in array order?

Answer 1

A:

without an order by clause mysql is free to return the result in any order it wants.

you'd have to specify the ordering with order by

knittl 2010-07-16 13:54:55

This is technically true but is not very helpful.

MJB 2010-07-16 13:57:29

Answer 2

+5 A:

select *
from Post 
where flag='0' and id in(4,5,1)
ORDER BY FIND_IN_SET(id, '4,5,1')

MySQL Doc for FIND_IN_SET

Crooy 2010-07-16 13:56:05

nice! (yadayada)

knittl 2010-07-16 14:00:52

Nice! it seems to give it to me in the order 1 5 4 (writing this as a note to others) but .Reverse() in .NET solves that :D

acidzombie24 2010-07-16 14:43:58

@acidzombie: you could also order by find_in_set(…) desc

knittl 2010-07-16 15:17:31

@knittl: Weird thing is, not only did it not do it but ASC and DESC dont get the same results in reverse order

acidzombie24 2010-07-16 15:24:18

Answer 3

A:

Try this instead:

SELECT * FROM Post WHERE flag='0' AND id = 4
UNION
SELECT * FROM Post WHERE flag='0' AND id = 5
UNION
SELECT * FROM Post WHERE flag='0' AND id = 1

It's horribly inefficient, but it won't require you to change your schema.

Craig Trader 2010-07-16 13:56:11

... and won't solve the problem.

MJB 2010-07-16 14:05:59

Answer 4

A:

A possible solution:

select *
from Post 
where flag='0' and id = 4
UNION
select *
from Post 
where flag='0' and id = 5
UNION
select *
from Post 
where flag='0' and id = 1

despart 2010-07-16 13:57:19

sql operates on sets, and mysql is free to return those union query in any order (although usually it returns them without reordering)

knittl 2010-07-16 13:58:21

This still does not address the question.

MJB 2010-07-16 14:00:22

MySql in array order?