order by rand()

[anto]

I'm trying to get a randomly selected set of rows from a select query. I'm trying something like 'select * from table_name where colum='xxxx' order by rand() limit 10' as outlined in the manual. Well the server refuse anything coming after the 'by'. Where I'm wrong?<br><br>thanks

 

[rycamor]

ORDER BY RAND() only works in the beta version of MySQL 3.23.xx.<br><br>To get a random record in earlier versions of MySQL, you need to do a little more work: <br><br>SELECT id,field1,field2,field3,id*0+RAND() as rand_rows FROM your_table WHERE field1='whatever' ORDER BY rand_rows LIMIT 10&quot;;<br><br>(assuming your primary key is 'id')

 

[antos]

Great! I'd never came to it. Thanks