SELECT * FROM table_name ORDER BY RAND();

Found at http://www.mysql.com/doc/M/a/Mathematical_functions.html
    
use:

SELECT * FROM table_name ORDER BY RAND() limit 1;

if you only want one result not all of them.