Selecting Random Field?
Posted: Fri Mar 12, 2010 8:16 am
After doing some search, I found these...
but sometime I found something like fast method or slow method,
what makes the difference?
and if it slow, how slow is it?
thanks,
Code: Select all
SELECT * FROM $table_name where status='yes' ORDER BY RAND() limit 1what makes the difference?
and if it slow, how slow is it?
thanks,