MySQL – SELECT … WHERE id IN (..) – correct order

by

Use FIELD():

SELECT * FROM table WHERE id IN (5,4,3,1,6) ORDER BY FIELD(id, 5,4,3,1,6);

Related Contents:

  1. MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
  2. Insert into a MySQL table or update if exists
  3. How can I find all the tables in MySQL with specific column names in them?
  4. MySQL error: key specification without a key length
  5. How to remove constraints from my MySQL table?
  6. MySQL search and replace some text in a field
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. How to get database structure in MySQL via query
  9. Select records from NOW() -1 Day
  10. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  11. How to define a custom ORDER BY order in mySQL
  12. MySQL: Can’t create table (errno: 150)
  13. How can I suppress column header output for a single SQL statement?
  14. Unknown Column In Where Clause
  15. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  16. mysql is not recognised as an internal or external command,operable program or batch
  17. What is a proper naming convention for MySQL FKs?
  18. Mysql order by specific ID values
  19. Print debugging info from stored procedure in MySQL
  20. MySQL – how many rows can I insert in one single INSERT statement?
  21. mysql SQL: specific item to be first and then to sort the rest of the items
  22. How can I show user’s privileges in MySQL?
  23. `mysql_upgrade` is failing with no real reason given
  24. Store the MySQL client password, or setup password less authentication
  25. Choosing a value for wait_timeout & interactive_timeout in MySQL config?
  26. Ruby on Rails 3 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ on OSX
  27. Scaling solutions for MySQL (Replication, Clustering)
  28. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  29. How can I undo a mysql statement that I just executed?
  30. Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’
  31. MySQL – Selecting a Column not in Group By
  32. LOAD DATA INFILE Error Code : 13
  33. How many databases can I create on a single Amazon RDS instance
  34. MySQL Update query with left join and group by
  35. mysql datatype for telephone number and address
  36. Are Users ‘User’@’%’ and ‘User’@’localhost’ not the same?
  37. MySQL add a NOT NULL column
  38. Mysql – How to update a column using another column’s value plus some strings
  39. How to make a primary key start from 1000?
  40. Working with INTERVAL and CURDATE in MySQL
  41. How to rename a view in MySQL?
  42. MySql: MyISAM vs. Inno DB! [closed]
  43. How to disable index in innodb
  44. String to timestamp in MySQL
  45. MySQL : Multiple row as comma separated single row
  46. mysql “Where not in” using two columns
  47. how to compute similarity between two strings in MYSQL
  48. MySQL 8 create new user with password not working
  49. Can’t create test file lower test start server mysql
  50. MySQL alias for SELECT * columns

Leave a Comment