MySql randomly retrieves a data entry from the table result set.

MySql randomly retrieves a data entry from the table result set.

[SQL] Select * from (Select (@ rowNo: = @ rowNo + 1) AS rowno, pwd from pur_admininfo, (Select @ rowNo: = 0) B) tmp where rowno = (Select Round (Rand () * 10000000% (Select Count (*) from pur_admininfo) limit 1;

 

In order to randomly obtain any record in the table result set, multiply the value by 10000000 and then modulo again, but I don't know why the bigger number is. Another implementation method:

[SQL] SELECT * FROM pur_admininfo AS t1 JOIN (SELECT ROUND (RAND () * (SELECT MAX (rid) FROM pur_admininfo)-(SELECT MIN (rid) FROM pur_admininfo )) + (select min (rid) FROM pur_admininfo) AS rid) AS t2 WHERE t1.rid> = t2.rid order by t1.rid LIMIT 1;