join my_records_used using (my_id)
where my_records_used.my_id is null
order by rand()
limit 1
> Date: Tue, 20 Apr 2004 13:08:01 -0700 (PDT)
> Subject: Re: Randomly selecting from table
> From: "Daniel Clark" <[EMAIL PROTECTED]>
> To: "Eve Atley" <[EMA
Guess you could use the rand() function and look for a matching row id!?!
> Is it possible to randomly select from all entries in a table, but have it
> be 2 different ones each time? If so, what documentation should I be
> looking
> at?
>
> I am using PHP and MySQL together, if this helps.
>
> Th
Is it possible to randomly select from all entries in a table, but have it
be 2 different ones each time? If so, what documentation should I be looking
at?
I am using PHP and MySQL together, if this helps.
Thanks,
Eve
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my