Mysql order by random
Add a column of random numbers to the column output list, alias it, and refer to the alias for sorting: 7. Selecting Random Items from a Set of Rows: 8. To draw five winning entries at random from a table named drawing that contains contest entries, use RAND( ) i: 9. get some random numbers: 10. Get some random numbers in the range 1-100: 11.