Selecting random mysql rows

[owainhunt]

Hoe can I select 10 random rows from a mysql table? This is for a section on my site where I select all names in a database who submitted a URL when they registered, then display 10 random ones of the page.

[Anon]

if u have the newest mysql-version:
SELECT foo FROM bar ORDER BY RAND()

greets
kai

[Anon]

forgot he wanted only 10...

select foo from bar order by rand() limit 10