Well, if you have an autonumber primary key, you could get the largest
existing value and generate a random key with the class Random in JBoss
Then retrieve the 1random recoord from the random key.

Hugo

----- Original Message -----
From: "Jack Lauman" <jlauman@(protected)>
To: <JSP-INTEREST@(protected)>
Sent: Wednesday, February 11, 2004 12: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 listserv@(protected)
JSP-INTEREST".
> For digest: mailto listserv@(protected)
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 listserv@(protected)".
For digest: mailto listserv@(protected)".

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