Pull a random record

[Jon7800]

Hello everyone,

Is there a way to pull a random record from MySQL?

Thanks!

Jon

[planetsim]

SELECT * FROM mytbl ORDER BY RAND( ) LIMIT 1;