subject:"\[PHP\-DB\] selecting random rows"

[PHP-DB] selecting random rows

2003-02-27 Thread kent

I'm sure this is pretty simple, but I'm having a hard time finding the answer: How do you select two random rows in a mysql table? Thanks, Kent

Re: [PHP-DB] selecting random rows

2003-02-27 Thread Leif K-Brooks

select * from table order by rand() limit 2 [EMAIL PROTECTED] wrote: I'm sure this is pretty simple, but I'm having a hard time finding the answer: How do you select two random rows in a mysql table? Thanks, Kent -- The above message is encrypted with double rot13 encoding. Any