List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 14 1999 2:00am
Subject:Re: Set types!!!
View as plain text  
The set (1, 2, 3) is not an element of the set (1, 2, 3, 4, 5, 6, 7).
IN works with an element.  You probably want one of these:

SELECT
        1 IN (1, 2, 3, 4, 5, 6)
    OR
        2 IN (1, 2, 3, 4, 5, 6)
    OR
        3 IN (1, 2, 3, 4, 5, 6)

SELECT
        1 IN (1, 2, 3, 4, 5, 6)
    AND
        2 IN (1, 2, 3, 4, 5, 6)
    AND
        3 IN (1, 2, 3, 4, 5, 6)

Tim


On Fri, May 14, 1999 at 09:44:14AM +0800, hgz wrote:
> hi all:
>         I want to know how to use mysql's fields type as:SET and ENUM
> I use as this:
>      select (1,2,3) in (1,2,3,4,5,6,7);
> why it doesn't works!!!
> Thanks in advances!
Thread
Set types!!!hgz14 May
  • Re: Set types!!!Paul DuBois14 May
  • Re: Set types!!!Thimble Smith14 May