well i have only 4 records in the table. When i use below mentioned query it always return the same record irrespective of time delay. Now wht can i do?
Thanks Binay > "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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
