How to define a custom ORDER BY order in mySQL

by

MySQL has a handy function called FIELD() which is excellent for tasks like this.

ORDER BY FIELD(Language,'ENU','JPN','DAN'), ID

Note however, that

  1. It makes your SQL less portable, as other DBMSs might not have such function

  2. When your list of languages (or other values to sort by) gets much longer, it’s better to have a separate table with sortorder column for them, and join it to your queries for ordering.

More Related Contents:

  1. MySQL: Return 2 different result together
  2. Get top n records for each group of grouped results
  3. Joining three tables using MySQL
  4. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  5. Can’t connect to MySQL server error 111 [closed]
  6. MySQL AUTO_INCREMENT does not ROLLBACK
  7. How to import a CSV file into a MySQL table
  8. How to store arrays in MySQL?
  9. Create new user in MySQL and give it full access to one database
  10. MySQL high CPU usage [closed]
  11. Most efficient way to get table row count
  12. How do I select between the 1st day of the current month and current day in MySQL?
  13. Subqueries with EXISTS vs IN – MySQL
  14. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  15. MySQL Cross Server Select Query
  16. How do I generate nested json objects using mysql native json functions?
  17. Allow all remote connections, MySQL
  18. Import CSV to MySQL
  19. MySQL Install: ERROR: Failed to build gem native extension
  20. MySQL TEXT vs BLOB vs CLOB
  21. MYSQL syntax not evaluating not equal to in presence of NULL
  22. Getting data for histogram plot
  23. How accurately should I store latitude and longitude?
  24. How can I use transactions in my MySQL stored procedure?
  25. MySQL: LAST_INSERT_ID() returns 0
  26. MySQL loop through tables
  27. INSERT INTO or UPDATE with two conditions
  28. What the difference between mysql and mysql2 gem
  29. XAMPP – Error: MySQL shutdown unexpectedly
  30. ERROR 1044 (42000): Access denied for ‘root’ With All Privileges

Leave a Comment