Hi, Since you're using MySQL you could always use this non-standard solution:
SELECT * FROM myTable ORDER BY rand() LIMIT 1 Brgds Mathias -----Ursprungligt meddelande----- Från: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED] Brian Sperryn Skickat: den 11 februari 2004 13:22 Till: [EMAIL PROTECTED] Ämne: Re: Java / MySQL Question rs.last(); int randomRow = (int)(Math.random()*rs.getRow()); rs.absolute(randomRow); *********** the usual get column stuff... *********** ----- Original Message ----- From: "Jack Lauman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 1:49 PM Subject: Java / MySQL 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. (Using MySQL 4.0.17 and JBoss 3.2.2) > > What is the most eficient way to do this? > > TIA > > Jack > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
