Random Sampling with SQLJune 27, 2016 by Jonathan DingmanKeep it simple.select *from table1where criteria1 = TRUEorder by random()limit 500Simple enough to get the job done and pulls a random sampling based on the result set.