Re: Query Question

[Alec . Cawley]

Jack Lauman <[EMAIL PROTECTED]> wrote on 11/02/2004 11:47:20:

> 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?

Try SELECT <columns> FROM <table> ORDER BY RAND() LIMIT 1 ;

      Alec


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]