Question

In MySQL, how can we randomize set of rows or values in the result set?

Answer 1

MySQL select random records using ORDER BY RAND() The RAND() function generates a random value for each row in the table. The ORDER BY clause sorts all rows in the table by the random number generated by the RAND() function. The LIMIT clause picks the first row in the result set sorted randomly.