Maybe you should say
WHERE category LIKE 'Gambling'
- Original Message -
From: Jeff Field <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 11:42 AM
Subject: ENUM query question
> I have a quick question regarding queries that involve
Yes! My apologies; didn't have my coffee this morning. The column is of
type SET.
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 12, 2002 12:50 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: ENUM que
At 12:42 -0500 6/12/02, Jeff Field wrote:
>I have a quick question regarding queries that involve values in ENUM
>columns. Here's the scenario:
>
>I have an ENUM column (category) that can have the values ('Gambling',
>'Geographic', 'Medical', 'Sports'). Most of the records have only one of
>the
I have a quick question regarding queries that involve values in ENUM
columns. Here's the scenario:
I have an ENUM column (category) that can have the values ('Gambling',
'Geographic', 'Medical', 'Sports'). Most of the records have only one of
the category descriptions but some are categorized