devmnj/random_rows_sqlite

Last active July 5, 2019 08:32

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/devmnj/99ce68dba3ef00bbe1c0f4adca83e0ec.js"></script>
Save devmnj/99ce68dba3ef00bbe1c0f4adca83e0ec to your computer and use it in GitHub Desktop.

Download ZIP

Generating sqlite random() rows

Raw

random_rows_sqlite

	select * from usedes order by random() limit 5

	# each time you run the query will swap rows

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment