"Binay" <[EMAIL PROTECTED]> wrote:
> 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?
What version of MySQL do you use?
>
> Thanks
> Binay
>
>> "Binay" <[EMAIL PROTECTED]> wrote on 21/06/20
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.
> >
"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/mysq
Hi all
I need to select randomnly just one record from the table.
how can i do? please help me out.
Thanks in advance
binay