get random entry from table

[hiasl]

Hi!

Is it possible to get one single random entry from a mysql table by using a special query?

e.g. something like

get * from table where id = random...

Thanks,
Matthias

[hiasl]

I found a solution in the forum!

select id, frage, rand() as random_col from faqs order by random_col limit 1

Matthias