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!
