Maintaining order in MySQL “IN” query

by

As the other answer mentions: the query you posted has nothing about what order you’d like your results, just which results you’d like to get.

To order your results, I would use ORDER BY FIELD():

SELECT * FROM foo f where f.id IN (2, 3, 1)
ORDER BY FIELD(f.id, 2, 3, 1);

The argument list to FIELD can be variable length.

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. MySQL: Alternatives to ORDER BY RAND()
  3. MySQL LIKE IN()?
  4. Auto Increment after delete in MySQL
  5. Unioning two tables with different number of columns
  6. NULL in MySQL (Performance & Storage)
  7. In MySQL queries, why use join instead of where?
  8. MySQL function to find the number of working days between two dates
  9. MySQL Trigger to prevent INSERT under certain conditions
  10. Importance of varchar length in MySQL table
  11. Stored Procedure with optional “WHERE” parameters
  12. SQLite – ORDER BY RAND()
  13. SQL – How to transpose?
  14. How to search multiple columns in MySQL?
  15. MySQL – Selecting data from multiple tables all with same structure but different data
  16. How to delete Duplicates in MySQL table
  17. How to ORDER BY a SUM() in MySQL?
  18. mySQL Returning the top 5 of each category
  19. SQL SELECT to get the first N positive integers
  20. Sorting string column containing numbers in SQL?
  21. Error: The used SELECT statements have a different number of columns
  22. Multiple Ranks in one table
  23. Create date from day, month, year fields in MySQL
  24. The difference between ‘AND’ and ‘&&’ in SQL
  25. Can I use a MySQL database with an App Engine application
  26. How can I make an average of dates in MySQL?
  27. How to combine aggregate functions in MySQL?
  28. What is the best way to generate ranks in MYSQL?
  29. I want to copy table contained from one database and insert onto another database table
  30. How do MySQL views work?

Leave a Comment