Selecting random rows with SQLite

A quick and easy way to select 100 rows randomly from a sqlite database:

SELECT * FROM UserRules 
ORDER BY Random() 
LIMIT 100
Advertisements