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. 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 in two or more of the
> category descriptions.
>
> When I do a query and my WHERE clause is
>
> WHERE category = 'Gambling'
>
> it only pulls the records for which 'Gambling' is the only value. To get
> *all* the records, including the records where the category value might be
> (Gambling, Sports), I have to use the wildcard, as in
>
> WHERE category = '%Gambling%'
>
> Here's the question:
>
> Although this may be exactly what I have to do to get those records, my own
> personal expectation was that the first query (without the wildcards) should
> have been fine. Is having to use wildcards with an ENUM column in the WHERE
> clause correct? Or, am I missing something here?
>
> Thanks!
>
> Jeff
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
