Sort by order of values in a select statement “in” clause in mysql

by

Actually, this is better:

SELECT * FROM your_table
WHERE id IN (5,2,6,8,12,1)
ORDER BY FIELD(id,5,2,6,8,12,1);

heres the FIELD documentation:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. MySQL – UPDATE query based on SELECT Query
  3. MySQL: is a SELECT statement case sensitive?
  4. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  5. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  6. MySQL Query – Records between Today and Last 30 Days
  7. Ordering by specific field value first
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. INSERT INTO…SELECT for all MySQL columns
  10. Combine Multiple child rows into one row MYSQL
  11. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  12. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  13. Checking multiple columns for one value
  14. MySQL difference between two rows of a SELECT Statement
  15. MySQL – How to search for exact word match using LIKE?
  16. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  17. MySQL How do you INSERT INTO a table with a SELECT subquery returning multiple rows?
  18. How do I get the first day of the week of a date in mysql?
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. quick selection of a random row from a large table in mysql
  21. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  22. mysql select sum group by date
  23. SELECT query return 1 row from each group
  24. MySQL – SQL_BIG_SELECTS
  25. Comma separated string of selected values in MySQL
  26. MySQL Select Query – Get only first 10 characters of a value
  27. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  28. MySQL Error: #1142 – SELECT command denied to user
  29. MySQL Select Multiple VALUES
  30. mySQL returns all rows when field=0

Leave a Comment