Prova ad usare RAND() ...

select * from tabella
order by RAND()
limit 1