MySQL Select WHERE IN given order -

MySQL Select WHERE IN given order -

i have like

select * table id in (118,17,113,23,72);

if returns rows in id ascending order. there way rows in order given in in statement?

you should utilize "order field". so, instance:

select * table id in (118,17,113,23,72) order field(id,118,17,113,23,72)

mysql