randomly choose a row from a result

[AN-net]

how would i achieve this? like say i chose everything from a table how would i randomly choose 5 rows from it?

[Boofo]

ORDER BY RAND()
LIMIT 5

[AN-net]

thanks yet again boofo;)

[Boofo]

You are very welcome, sir. ;)