How to fetch random data from database

$query="SELECT * FROM product ORDER BY RAND( )LIMIT 0 , 5 ";
$result=mysql_query($query);