To randomly select any single record in MySQL you need to execute the following MySQL statement:
select * from tablename order by rand() limit 1
The above statement returns a single record randomly.
For multiple records you need to execute the following statements:
select * from tablename order by rand()
0 Comment(s)