Random Rowset in MySQL

[Anon]

Is there anyway to jump from row to row in PHP / MySQL?

I have all this information in a database but instead of pulling it out by DESC or ASC I want to randomaly pull lines out.

Thanks,

Dan

[Anon]

I haven't tried it in mysql, but you should be able to ORDER the result set with the SQL "RAND()" function, which might give you what you want.

[Anon]

That suggests a sql select with the LIMIT random,1 suffix for each random record you want to retrieve.

Depending on the size of the total table and the number of records you want to retrieve consider fetching the data into a PhP array and randomly accessing this.