Prova così

select * from tabella order by rand(curdate()) limit 1