Selecting Random Rows in MySQL

by

You can use the rand function in MySQL to order the rows, and then take the top 10 (or however many you want) with limit.

select * from table order by rand() limit 10

If you want just the math questions:

select * from table where type = 1 order by rand() limit 10

More Related Contents:

  1. INNER JOIN ON vs WHERE clause
  2. How to SELECT the newest four items per category?
  3. MySQL: Alternatives to ORDER BY RAND()
  4. MySQL LIKE IN()?
  5. Auto Increment after delete in MySQL
  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. Stored Procedure with optional “WHERE” parameters
  11. SQLite – ORDER BY RAND()
  12. MySQL syntax for Join Update
  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. SQL SELECT to get the first N positive integers
  17. Sorting string column containing numbers in SQL?
  18. Error: The used SELECT statements have a different number of columns
  19. Multiple Ranks in one table
  20. Create date from day, month, year fields in MySQL
  21. The difference between ‘AND’ and ‘&&’ in SQL
  22. Can I use a MySQL database with an App Engine application
  23. How can I make an average of dates in MySQL?
  24. How to combine aggregate functions in MySQL?
  25. What is the best way to generate ranks in MYSQL?
  26. How important are lookup tables?
  27. how to use LIKE with column name
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment