Sort the rows according to the order specified in WHERE IN clause

by

You should use “ORDER BY FIELD“. So, for instance:

SELECT * FROM table WHERE id IN (118,17,113,23,72) 
ORDER BY FIELD(id,118,17,113,23,72)

More Related Contents:

  1. How does MySQL process ORDER BY and LIMIT in a query?
  2. Ordering by the order of values in a SQL IN() clause
  3. Ordering by specific field value first
  4. MySQL “Group By” and “Order By”
  5. Using union and order by clause in mysql
  6. SQL order string as number
  7. MySQL order by “best match”
  8. Order by COUNT per value
  9. MySQL/MariaDB – order by inside subquery
  10. Mysql: Order by like?
  11. ORDER BY alphabet first then follow by number
  12. MYSQL Select One Random record from each Category
  13. how to delete data from table A besides the customer service and director data in table B?
  14. SQL split values to multiple rows
  15. Get records with max value for each group of grouped SQL results
  16. How to populate a table with a range of dates?
  17. MySQL order by before group by
  18. Convert timestamp to date in MySQL query
  19. Update a column value, replacing part of a string
  20. MySQL combine two columns into one column
  21. MySQL Insert Into from one Database in another
  22. MySQL: LIMIT by a percentage of the amount of records?
  23. MySQL multiple columns in IN clause
  24. GROUP BY – do not group NULL
  25. Composite key as foreign key (sql)
  26. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  27. MySQL LEFT JOIN 3 tables
  28. MySQL OPTIMIZE all tables?
  29. Strip last two characters of a column in MySQL
  30. Deleting a row based on the max value

Leave a Comment