Selecting Random Field?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
nitediver
Forum Contributor
Posts: 109
Joined: Tue Feb 24, 2009 9:05 am

Selecting Random Field?

Post 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,
User avatar
tr0gd0rr
Forum Contributor
Posts: 305
Joined: Thu May 11, 2006 8:58 pm
Location: Utah, USA

Re: Selecting Random Field?

Post by tr0gd0rr »

nitediver
Forum Contributor
Posts: 109
Joined: Tue Feb 24, 2009 9:05 am

Re: Selecting Random Field?

Post by nitediver »

long...
but thanks...
Post Reply