I think he's trying to do sth. like that SELECT quote FROM quotes ORDER BY RAND() LIMIT 1
On 5/8/2008, "John Stanton" <[EMAIL PROTECTED]> wrote: >Sorting in random order is a definite contradiction in terms. What are >you actually trying to do? > >Barbara Weinberg wrote: >> Hi >> I was wondering whether anyone had tried sorting records in random order >> using sqlite3. I tried sorting by random() and randomblob() but it was very >> slow and chewed up lots of resources. Any suggestions? >> Barbara >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >_______________________________________________ >sqlite-users mailing list >sqlite-users@sqlite.org >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users