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 values in ENUM
> columns.
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
