ORDER BY value of index - not position

anjanesh · #1 (**permalink**) 03-05-06, 06:09

I have a MySQL query

Code:

SELECT `Id`, `Info` 
FROM `tbl1` 
WHERE `Id` = 5 OR `Id` = 1 OR `Id` = 3

I want it returned as

Code:

5, info5
1, info1
3, info3

Im not looking for position - position looks at the order of Id - Im looking for the value of Id.
Is there any way to accomplish this ? Or would I need to execute 3 separate queries ?

Thanks

r937 · #2 (**permalink**) 03-05-06, 06:23

Code:

select id
     , info 
  from tbl1 
 where id in (5,1,3)
order
    by field(id,5,1,3)

anjanesh · #3 (**permalink**) 03-05-06, 06:47

Cannot believe I skipped this from the manual.
Thanks r937 - you've always been prmopt and helpful. Your time here is truly appreciated.

Strange though - it works in phpMyAdmin but not my PHP script
FUNCTION db1.FIELD does not exist
I have in m script

Code:

$Res = mysql_query($SQL) or die("\n<!--$SQL-->\n".mysql_error());

I exectued what was inbetween  and worked !

Internet Services

Web Development

Digital Marketing

Consumer Tech