Mysql order by specific ID values

by

You can use ORDER BY and FIELD function.
See http://lists.mysql.com/mysql/209784

SELECT * FROM table ORDER BY FIELD(ID,1,5,4,3)

It uses Field() function, Which “Returns the index (position) of str in the str1, str2, str3, … list. Returns 0 if str is not found” according to the documentation. So actually you sort the result set by the return value of this function which is the index of the field value in the given set.

More Related Contents:

  1. How to find similar results and sort by similarity?
  2. Mysql: Select rows from a table that are not in another
  3. Sorting varchar field numerically in MySQL
  4. MySQL: Sort GROUP_CONCAT values
  5. ORDER BY date and time BEFORE GROUP BY name in mysql
  6. updating columns with a sequence number mysql
  7. mysql sorting of version numbers
  8. is php sort better than mysql “order by”?
  9. mysql custom sort
  10. ORDER BY alphabet first then follow by number
  11. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  12. SQL split values to multiple rows
  13. How do I escape reserved words used as column names? MySQL/Create Table
  14. How to populate a table with a range of dates?
  15. What is the opposite of GROUP_CONCAT in MySQL?
  16. How to Perform an UPSERT so that I can use both new and old values in update part
  17. brew install mysql on macOS
  18. MySQL: selecting rows where a column is null
  19. How do I check to see if a value is an integer in MySQL?
  20. How do I select an entire row which has the largest ID in the table?
  21. MySQL error 1064 syntax but everything seems fine
  22. MySQL/MariaDB – order by inside subquery
  23. How to run SQL script in MySQL?
  24. Removing MySQL 5.7 Completely [closed]
  25. How to optimize COUNT(*) performance on InnoDB by using index
  26. script to convert mysql dump sql file into format that can be imported into sqlite3 db
  27. ERROR 1148: The used command is not allowed with this MySQL version
  28. Too many auto increments with ON DUPLICATE KEY UPDATE
  29. Put MySQL database under version control?
  30. Laravel Eloquent Ignore Casing

Leave a Comment