http://snipplr.com/language/mysql/tags/random Recent snippets posted on Snipplr.com en-us Sat, 25 May 2013 02:46:42 GMT http://snipplr.com/view/22838/generate-random-string-in-mysql/

]]> Tue, 10 Nov 2009 04:43:58 GMT http://snipplr.com/view/22838/generate-random-string-in-mysql/ http://snipplr.com/view/20485/get-random-record-based-on-weight/ Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.

]]> Wed, 30 Sep 2009 15:09:16 GMT http://snipplr.com/view/20485/get-random-record-based-on-weight/ http://snipplr.com/view/14199/get-random-record-in-table/ This code is useful if you have a table where some records have been deleted. This code will favor records after large blocks of deleted records. 1) Get max id 2) generate random number with the max id 3) Query DB with random number.

]]> Mon, 20 Apr 2009 11:31:55 GMT http://snipplr.com/view/14199/get-random-record-in-table/