[Gllug] Perl DBI question

[Adrian McMenamin]

On Mon, 2006-10-02 at 23:09 +0100, Ryan Cartwright wrote:

> 
> Isn't this just a case of using rand[om] within your SQL?
> 
> SELECT * FROM TABLE1 ORDER BY RAND() LIMIT 1; -- MySQL
> 
> SELECT * FROM TABLE1 ORDER BY RANDOM() LIMIT 1; -- PostgreSQL
Looks worth a try!

-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug