I have a list of numbers: 7,1,3,2,123,55 (which are the ids of existing records)
I have a mysql table with the colums id and name, where id is an integer primary key.
I want to select records from this table, but in a specific order, for example 7,1,3,2,123,55.
- Is it possible to do this in MyISAM within query, without any post processing?
- What is the simplest way to do this?