mysql custom sort

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

Source: http://imthi.com/blog/programming/mysql-order-by-field-custom-field-sorting.php

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 order by specific ID values
  5. MySQL: Sort GROUP_CONCAT values
  6. ORDER BY date and time BEFORE GROUP BY name in mysql
  7. updating columns with a sequence number mysql
  8. mysql sorting of version numbers
  9. is php sort better than mysql “order by”?
  10. ORDER BY alphabet first then follow by number
  11. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)
  12. Joining three tables using MySQL
  13. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  14. MySQL Orderby a number, Nulls last
  15. Troubleshooting “Illegal mix of collations” error in mysql
  16. How should I store GUID in MySQL tables?
  17. How to perform a mysqldump without a password prompt?
  18. Select the 3 most recent records where the values of one column are distinct
  19. Mysql count instances of substring, then order by
  20. How to remove leading and trailing whitespace in a MySQL field?
  21. How to reset the root password in MySQL 8.0.11?
  22. How does MySQL CASE work?
  23. What characters have to be escaped to prevent (My)SQL injections?
  24. How to save MySQL query output to excel or .txt file? [duplicate]
  25. MySQL: Set user variable from result of query
  26. Is there any performance gain in indexing a boolean field?
  27. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  28. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  29. How to swap values of two rows in MySQL without violating unique constraint?
  30. MYSql config bind-address set to 0.0.0.0 but netstat shows different on Ubuntu

Leave a Comment