Snipplr http://snipplr.com/language/sql/tags/random Recent snippets posted on Snipplr.com en-us Thu, 20 Jun 2013 04:18:43 GMT (SQL) Mysql Random Number Generate - metoikos http://snipplr.com/view/45092/mysql-random-number-generate/

]]> Wed, 01 Dec 2010 09:18:40 GMT http://snipplr.com/view/45092/mysql-random-number-generate/ (SQL) Order By Rand() Alternative - traeregan http://snipplr.com/view/24242/order-by-rand-alternative/ Using subqueries...

]]> Fri, 04 Dec 2009 00:17:29 GMT http://snipplr.com/view/24242/order-by-rand-alternative/ (SQL) Randomize Query in SQL - blackf0rk http://snipplr.com/view/13058/randomize-query-in-sql/ Sometimes you want to return a bunch of data from a table, but you want it coming back in a random order. Maybe it's for keeping some content on a home page fresh. Here's how:

]]> Thu, 12 Mar 2009 17:21:54 GMT http://snipplr.com/view/13058/randomize-query-in-sql/ (SQL) Creating a random password using dictionary table - mynameisharry http://snipplr.com/view/11314/creating-a-random-password-using-dictionary-table/ Create a random password using a Dictionary database table. Selects a random word, and then appends two random numbers to the end, creating passwords in the form of: foozling98 or laicism11

]]> Mon, 19 Jan 2009 10:27:26 GMT http://snipplr.com/view/11314/creating-a-random-password-using-dictionary-table/ (SQL) MySQL random password string - stancell http://snipplr.com/view/5935/mysql-random-password-string/

]]> Mon, 21 Apr 2008 12:38:10 GMT http://snipplr.com/view/5935/mysql-random-password-string/ (SQL) Random Sorting - mafro http://snipplr.com/view/2515/random-sorting/ Random sort of SQL set

]]> Mon, 23 Apr 2007 05:49:34 GMT http://snipplr.com/view/2515/random-sorting/ (SQL) Sort by random character - mafro http://snipplr.com/view/2514/sort-by-random-character/ Sort a result set by a random letter - this example uses the alphabet and a column named 'text'

]]> Mon, 23 Apr 2007 05:04:16 GMT http://snipplr.com/view/2514/sort-by-random-character/