WHERE IN子句在IN中显示它们的索引结果

Question

i have a table, just id and name, have a mysql like this

`SELECT * FROM table WHERE id IN(154,12,148,50);`

and i use while loop PHP for display result as normal way :

while($rows= mysql_fetch_array($result)){ echo $rows['id'], echo $rows['name'] }

but result is ordered by id field in IN clause 12 ,50,148,154

i want to result still them index in IN() : 154,12,148,50

is there any way?

thank alot

Answer 1

read FIELD

SELECT * 
FROM table 
WHERE id IN(154,12,148,50)
ORDER BY FIELD(id,154,12,148,50)