MySQL ORDER BY rand(), name ASC

by

Use a subquery:

SELECT * FROM 
(
    SELECT * FROM users ORDER BY rand() LIMIT 20
) T1
ORDER BY name

The inner query selects 20 users at random and the outer query orders the selected users by name.

More Related Contents:

  1. MySQL: Select Random Entry, but Weight Towards Certain Entries
  2. Selecting all fields except only one field in mysql [duplicate]
  3. Using PHP data in MySQL [closed]
  4. which is better every user have a table or just a row [closed]
  5. PHP – Change value y,n in database [closed]
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Many-to-many relationships examples
  8. strange character encoding of stored data , old script is showing them fine new one doesn’t
  9. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  10. How to upload images into MySQL database using PHP code
  11. PDO mysql: How to know if insert was successful
  12. How to loop through a mysql result set
  13. MySQL check if a table exists without throwing an exception
  14. Maximum execution time in phpMyadmin
  15. Mysql No connection could be made because the target machine actively refused it
  16. Replacing mysql_* functions with PDO and prepared statements
  17. Selecting all columns that start with XXX using a wildcard?
  18. Is there any way to check the performance of mysql Indexing
  19. IP address storing in MySQL database using PHP [duplicate]
  20. phpmyadmin automatic logout time
  21. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  22. MySQL skipping first row
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. How do I set the selected item in a drop down box
  25. Fatal error: Call to undefined function mysqli_result()
  26. Laravel nested relationships
  27. select within 20 kilometers based on latitude/longitude
  28. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  29. Auto Increment skipping numbers?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment