t;
> Christian
>
> -Original Message-
> From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Saturday, 15 January 2005 12:56 AM
> To: Christian Biggins; mysql@lists.mysql.com
> Subject: Re: Selecting a random record from more than 1 table
>
>
> - Original Message -
- Original Message -
From: "Christian Biggins" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 14, 2005 12:07 AM
Subject: Selecting a random record from more than 1 table
> Hi Guys
>
> I am trying to display 1 random record taken from 2 tables.
>
> I have tried the following;
>
> SELECT
See section 7.39 of the manual. 'when' is a reserved word in 3.23.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Alan Halls [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 15:15
> To: [EMAIL PROTECTED]
To simplify
SELECT Field1, Field2, Field3 ORDER BY Rand() LIMIT 1;
At 10:01 AM 1/15/2001 -0700, Alan Halls wrote:
> On the site Adoption.com we have been using a mysql database to
> set up
>families who want to adopt. We have since redesigned our site and the old
>code is not working fo
