selecting random db entry

[Anon]

Is there any way to select a random row from a table?

usually I'd use the rand() function in relation to a field in the table with unique id numbers (1-100 or whatever), but this table has a file name and a second field to mark whether the file has been used yet or not ('n' or 'y').

I was hoping that 'select rendom * from table' would werk, but it doesn't..

Any ideas?

Tanks,
Lazzerous

[Anon]

you could use rand to generate number from 1 to the number of record you have (count() them).
Then use mysql_seek_data()this will move to the record
then use fetch_array or row to retun information - hope this helps

[Anon]

Since MySql supports "limit offset, rows" you can have your
second query return exactly one row.