Random record?

[hussainz2000]

Hi all..
i have a database which contain alot of records,
i want to select one <b>RANDOM</b> record from this record ...how can i do it?
bye

[[deleted]]

Which database?

[hussainz2000]

Sorry for unclear....
i mean if i have table this table in MYSQL ..how can i chose random on record from it?

[[deleted]]

SELECT *
FROM table
WHERE bladebla
ORDER BY rand()
LIMIT 1