Posted by Qun Cao on 11/06/65 11:31

thanks, Geoff.
Actually I just found this rather convenient sql command:
select * from table order by rand() limit 1;
returns one random entry from the table, exactly what i needed! :)

qun

• Next in forum: Re: MySQL question- random entry
• Prev in forum: Re: MySQL question- random entry
• Thread view: Re: MySQL question- random entry

[Reply to this message]