运算符IN 用来判断表达式的值是否在给出的列表中,如果是,返回值为1,否则返回值为0; not IN 则相反 表达式:IN(value1,value2,…) NOT IN (value1,value2…) eg1:SELECT 2 IN (1,3,5,‘aaa’),‘aaa’ IN (1,3,5, ‘aaa’); eg2:SELECT 2 NOT IN (1,3,5,‘aaa’),‘aaa’ NOT IN (1,3,5, ‘aaa’);
mysql 运算符 IN 和 NOT IN运算符IN 用来判断表达式的值是否在给出的列表中,如果是,返回值为1,否则返回值为0; not IN 则相反表达式:IN(value1,value2,…)NOT IN (value1,value2…)eg1:SELECT 2 IN (1,3,5,‘aaa’),‘aaa’ IN (1,3,5, ‘aaa’); eg2:SELECT 2 NOT IN (1,3,5,‘aaa’),‘aaa’ NOT IN (1,3,5, ‘aaa’);...