MySQL ORDER BY IN()

by

I think you may be looking for function FIELD — while normally thought of as a string function, it works fine for numbers, too!

ORDER BY FIELD(field_name, 3,2,5,7,8,1)

More Related Contents:

  1. Laravel – only a zero is saved to the database
  2. storing user_id in session variable
  3. I am seeing this error on submitting form Error: query was empty [closed]
  4. mysqli or die, does it have to die?
  5. Convert from MySQL datetime to another format with PHP
  6. MySQL vs MySQLi when using PHP [closed]
  7. How do I set ORDER BY params using prepared PDO statement?
  8. Passing an array to a query using a WHERE clause
  9. How can I store and retrieve images from a MySQL database using PHP?
  10. PHP/MySQL Insert null values
  11. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  12. PHP file cannot enter some part of code
  13. Laravel: PDOException: could not find driver
  14. Can you add an if statement in ORDER BY?
  15. PDO Connection Test
  16. Grouping WHERE clauses in Codeigniter
  17. Using if(isset($_POST[‘submit’])) to not display echo when script is open is not working
  18. MySQL (or PHP?) group results by field data
  19. SELECT COUNT() vs mysql_num_rows();
  20. Store procedures in phpMyAdmin
  21. Check if a row exists using old mysql_* API
  22. Unique IPs in a voting system
  23. MySQL get a random value between two values
  24. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  25. php password_verify() hash and pass won’t match
  26. MySQL query using an array [duplicate]
  27. PHP mySQL – Insert new record into table with auto-increment on primary key
  28. Using MySQL’s TIMESTAMP vs storing timestamps directly
  29. How do I save PHP session data to a database instead of in the file system?
  30. Escaping SQL queries in Codeigniter

Leave a Comment