I've got the same problem with a WHERE condition :-)
Eric JESOVER http://eric.jesover.net -----Original Message----- From: Caleb Groom [mailto:[EMAIL PROTECTED] Sent: Wednesday 14 January 2004 18:32 To: sqlite users Subject: [sqlite] random record Does sqlite have some way to fetch a random record? I'm looking for something similar to MySQL's 'select * from tbl order by rand() limit 1'. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
