Order by IN()

[misk0]

select avatar, user_id from jos_comprofiler where user_id in (71,73,66,70,64,69)


zelim da mi vrati slogove slozene po tom redoslijedu u IN klauzuli..

ili postoji neki drugi nacin??

hvala

[japan]

select avatar, user_id from jos_comprofiler where user_id in (71,73,66,70,64,69) order by field(user_id,71,73,66,70,64,69)

mislim da ce ovo da radi, a mozda moze i pametnije...

[misk0]

select avatar, user_id from jos_comprofiler where user_id in (71,73,66,70,64,69) order by field(user_id,71,73,66,70,64,69)

mislim da ce ovo da radi, a mozda moze i pametnije...

Jeste, radi... hvala.