Page 1 of 1

Selecting Random Field?

Posted: Fri Mar 12, 2010 8:16 am
by nitediver
After doing some search, I found these...

Code: Select all

SELECT * FROM $table_name where status='yes' ORDER BY RAND() limit 1
but sometime I found something like fast method or slow method,
what makes the difference?
and if it slow, how slow is it?

thanks,

Re: Selecting Random Field?

Posted: Fri Mar 12, 2010 3:30 pm
by tr0gd0rr

Re: Selecting Random Field?

Posted: Sat Mar 13, 2010 7:51 am
by nitediver
long...
but thanks...