MySQL – ORDER BY values within IN()

by 
SELECT id, name
FROM mytable
WHERE name IN ('B', 'A', 'D', 'E', 'C')
ORDER BY FIELD(name, 'B', 'A', 'D', 'E', 'C')

The FIELD function returns the position of the first string in the remaining list of strings.

However, it is much better performance-wise to have an indexed column that represents your sort order, and then sort by this column.

More Related Contents:

  1. SELECTING with multiple WHERE conditions on same column
  2. MySQL order by before group by
  3. WHERE vs HAVING
  4. Why does MYSQL higher LIMIT offset slow the query down?
  5. MySQL ‘Order By’ – sorting alphanumeric correctly
  6. MySQL Orderby a number, Nulls last
  7. How does MySQL process ORDER BY and LIMIT in a query?
  8. Ordering by the order of values in a SQL IN() clause
  9. Order a MySQL table by two columns
  10. MySQL join with where clause
  11. Detect if value is number in MySQL
  12. SQL order string as number
  13. GROUP_CONCAT ORDER BY
  14. What is MySQL row order for “SELECT * FROM table_name;”?
  15. Slow query when using ORDER BY
  16. Select the 3 most recent records where the values of one column are distinct
  17. MySQL: Sort GROUP_CONCAT values
  18. MySQL order by “best match”
  19. Order by COUNT per value
  20. MySQL Order before Group by
  21. MySQL Select last 7 days
  22. ORDER BY date and time BEFORE GROUP BY name in mysql
  23. Returning query results in predefined order
  24. Mysql delete statement with limit
  25. Mysql: Order by like?
  26. Sort the rows according to the order specified in WHERE IN clause
  27. ORDER BY alphabet first then follow by number
  28. mySQL returns all rows when field=0
  29. MYSQL Select One Random record from each Category
  30. mysql order by, null first, and DESC after

Leave a Comment