[sqlite] Re: random record

[Ron Aaron]

On Wednesday 14 January 2004 09:32 am, Caleb Groom wrote:
> 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'.

Same thing:

SELECT * FROM tbl ORDER BY random() LIMIT 1;

works for me.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]