Comparison of four methods and performance for querying random data in MySQL

To calculate the offset of the first line, we use the RAND () method of MySQL to generate a random number from 0 to 1. Then we multiply this number by the number of records in the inverted table obtained using the COUNT () method. Since the LIMIT parameter must be int type but not float, we use FLOOR () to process the result. FLOOR () calculates the value smaller than the maximum value of the expression. Final

To calculate the offset of the first line, we use the RAND () method of MySQL to generate a random number from 0 to 1. Then we multiply this number by the number of records in the inverted table obtained using the COUNT () method. Since the LIMIT parameter must be int type but not float, we use FLOOR () to process the result. FLOOR () calculates the value smaller than the maximum value of the expression. Final

To calculate the offset of the first line, we use the RAND () method of MySQL to generate a random number from 0 to 1. Then we multiply this number by the number of records in the inverted table obtained using the COUNT () method. Since the LIMIT parameter must be int type but not float, we use FLOOR () to process the result. FLOOR () calculates the value smaller than the maximum value of the expression. The final code is as follows: