select random entry from table

[Anon]

Hi

I want write a script that selects a random entry from MySQL table.

Can anyone tell me is there a special command in MySQL.

Prox

[toma42]

select rand() as randthing, key from table order by randthing limit 1

[Anon]

you have to use :
select --- from yourtable where
dbms_utility.get_hash_value(dum(rowid),
0,100)<10;