t you the same thing
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 2:27 PM
To: CF-Talk
Subject: RE: quick mysql 4.0.17 query question...
Ah...that might work, than
Ah...that might work, thank you Claude.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 1:20 PM
To: CF-Talk
Subject: Re: quick mysql 4.0.17 query question...
>>Is it possible to do this in
one query and if so how might I d
>>Is it possible to do this in
one query and if so how might I do that?
I would try a UNION between 3 SELECTs, one for each possible option.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam
by the way, the structure of the table is as follows:
id (auto-increment)
name (varchar: 50)
type (enum: 'A','L','P')
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 1:13 PM
To: CF-Talk
Subject: qui
I've got a table with an ENUM column that has 3 possible options. I want to
return 4 random entries for each option. I know how to get N random records,
but this requires that I get 4 of each type. Is it possible to do this in
one query and if so how might I do that?
~~
5 matches
Mail list logo