A quick and easy way to select 100 rows randomly from a sqlite database:
SELECT * FROM UserRules ORDER BY Random() LIMIT 100
Filed under: python, sql | Tagged: python, select random rows, sqlite | Leave a comment »
Selecting random rows with SQLite
Posted on August 2, 2012 by Yael
Code and Chaos 