[SOLVED] Array and IN ()

[jaymc]

2: when using mysql IN(), for example WHERE id IN(1,2,3,4) if number 4 is the first id in the table, that will be the first returned when using the likes of mysql_fetch_assoc

 

How can I get mysql to return the results in the order I specify in the IN() clause, so in the case above rows 1,2,3,4

 

Edit: Can this be moved to MYSQL I answered my php question after posting so edited it out

[Rohan Shenoy]

For 1. Use the array_pad() function

or

use the array_reverse(), array_push(), and then again array_reverse() function.

[jaymc]

Does anyone know the answer to the MYSQL issue?

[rhodesa]

You can't get them to return in the order of the IN values. But, if they are always in increasing order, you can use an ORDER BY clause:

 

SELECT * FROM tablename WHERE id IN(1,2,3,4) ORDER BY id

[PFMaBiSmAd]

Here are a couple of ways of doing arbitrary ordering (assuming your don't want ascending or descending order) -

 

http://www.shawnolson.net/a/722/mysql-arbitrary-ordering.html

 

http://www.eklekt.com/tutorials/mysql

[sasa]

SELECT * FROM tablename WHERE id IN(1,2,3,4) ORDER BY FIELD(id,1,4,3,2)

[rhodesa]

Wow, I can't believe I've never seen ORDER BY FIELD before...very useful.

[jaymc]

SELECT * FROM tablename WHERE id IN(1,2,3,4) ORDER BY FIELD(id,1,4,3,2)

 

Excellent.