SELECT * FROM test ORDER BY RAND() LIMIT 1; See pp. 694-695 in the MySQL Cookbook.
____________________________________________________________ Eamon Daly NextWave Media Group LLC Tel: 1 773 975-1115 Fax: 1 773 913-0970 ----- Original Message ----- From: "Jack Lauman" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 5:47 AM Subject: Query Question > I have a table containing information about different businesses. I > want to randomly select a single row from the table using a prepared > statement in a java bean. > > What is the most eficient way to do this? > > TIA > > Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
