"Binay" <[EMAIL PROTECTED]> wrote on 21/06/2004 15:03:34:
> I need to select randomnly just one record from the table.
> how can i do? please help me out.
SELECT * FROM tbl_name 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]
