Selecting a random row

2 Message(s) by 2 Author(s) originally posted in mysql discussion

From: laredotornado

Date: Wednesday, October 24, 2007

Hi,

I'm using MySQL 5.0 and have InnoDB tables. How do I select a random,
single row

<data, database, programming> An {ordered set} of {fields},
	usually stored contiguously.  The term is used with similar
	meaning in several different contexts.  In a file, a "record"
	probably has some fixed length, in contrast to a "line" which
	may have any length and is terminated by some {End Of Line}
	sequence).  A {database} record is also called a "row".  In a
	{spreadsheet} it is always called a "row".  Some programming
	languages use the term to mean a type composed of fields of
	several other types ({C} calls this a "{struct}").

	In all these cases, a record represents an entity with certain
	field values.

	Fields may be of a fixed width ({bits} or {characters}) or
	they may be separated by a {delimiter} character, often
	{comma} ({CSV}) or {HT} ({TSV}).

	In a database the list of values of a given field from all
	records is called a column.

	(2002-03-22)

of data

<data, data processing, jargon> /day't*/ (Or "raw data")
	Numbers, {characters}, {images}, or other method of recording,
	in a form which can be assessed by a human or (especially)
	input into a {computer}, stored and {processed} there, or
	transmitted on some {digital channel}.  Computers nearly
	always represent data in {binary}.

	Data on its own has no meaning, only when interpreted by some
	kind of {data processing system} does it take on meaning and
	become {information}.

	People or computers can find patterns in data to perceive
	information, and information can be used to enhance
	{knowledge}.  Since knowledge is prerequisite to wisdom, we
	always want more data and information.  But, as modern
	societies verge on {information overload}, we especially need
	better ways to find patterns.

	1234567.89 is data.

	"Your bank balance has jumped 8087% to $1234567.89" is
	information.

	"Nobody owes me that much money" is knowledge.

	"I'd better talk to the bank before I spend it, because of
	what has happened to other people" is wisdom.

	(1999-04-30)

from a given table, "T"?

Thanks, - Dave

From: Captain Paralytic

Date: Thursday, October 25, 2007

On 24 Oct, 23:36, "laredotorn...@xxxxxxxxxxx"
wrote in message:

Hi,
I'm using MySQL 5.0 and have InnoDB tables. How do I select a random,
single row of data from a given table, "T"?
Thanks, - Dave

It is a 3 step process:

1) You use Google

<World-Wide Web> The {World-Wide Web} {search engine} that
	indexes the greatest number of web pages - over two billion by
	December 2001 and provides a free service that searches this
	index in less than a second.

	The site's name is apparently derived from "{googol}", but
	note the difference in spelling.

	The "Google" spelling is also used in "The Hitchhikers Guide
	to the Galaxy" by Douglas Adams, in which one of Deep
	Thought's designers asks, "And are you not," said Fook,
	leaning anxiously foward, "a greater analyst than the
	Googleplex Star Thinker in the Seventh Galaxy of Light and
	Ingenuity which can calculate the trajectory of every single
	dust particle throughout a five-week Dangrabad Beta sand
	blizzard?"

	{Home (http://www.google.com/)}.

	(2001-12-28)

to search this group

A group G is a non-empty {set} upon which a {binary} operator
	* is defined with the following properties for all a,b,c in G:

	  Closure:     G is closed under *,  a*b in G
	  Associative: * is associative on G, (a*b)*c = a*(b*c)
	  Identity:    There is an identity element  e  such that
		       a*e = e*a = a.
	  Inverse:     Every element has a unique inverse a' such that
		       a * a' = a' * a = e.  The inverse is usually
		       written with a superscript -1.

	(1998-10-03)

for the word "random"
2) You read a couple of the posts there that explain how to do it
3) You do it

Next Message: UNIQUE constraint and RAND() function?

Blogs related to Selecting a random row

PHP And MySQL Interview Questions
-d, –no-data Don’t write any row information for the table. This is very useful if you just want to get a dump of the structure for a table! Q:41 How can we optimize or increase the speed of a MySQL select ...

Tip: Selecting random row with MySQL and ActiveRecord
Here's a quick tip on how to select a random model instance from an ActiveRecord model when the database is MySQL: Model.find(:first, :order => 'rand()', :limit => 1) Please note:. Using rand() is MySQL specific; It performs bad when ...

MySQL Reference
The first row is number (eg, SELECT url FROM links LIMIT 5,10 returns URLs numbered 5 through 14). PROCEDURE name ([ arg_list]). In early versions of MySQL, this does not do anything. It was provided to make importing data from other ...

selected scenes in macbeth
... selecting process selecting projects selecting quality tool selecting quality tools selecting quilt fabric selecting radio buttons selecting ram selecting random records selecting random records from database selecting random rows ...

Random Timestamps in MySQL
Have you ever needed a random timestamp in MySQL? For example to create demo data programmatically? Here’s my solution: SELECT FROM_UNIXTIME( FLOOR( UNIX_TIMESTAMP('2007-01-01') + RAND() ...

Selecting a Random Row from a MySQL Table
In order to ensure that I could select a random lyric with every page request, I needed to be able to select a random row from a lyrics table in my database. To accomplish this, I first needed to get a count of all the lyrics currently ...