How to use IN and NOT IN in MySQL

This article is about how to use IN and NOT IN in MySQL. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Grammatical format of 1.IN and NOT IN

The IN operator in MySQL is used to determine whether the value of the expression is in the given list; if so, the return value is 1, otherwise the return value is 0.

Expr IN (value1, value2, value3... ValueN)

The role of NOT IN is the opposite of IN. NOT IN is used to determine whether the value of the expression does not exist in the given list; if not, the return value is 1, otherwise the return value is 0.

Expr NOT IN (value1, value2, value3... ValueN)

Expr represents the expression to be judged, value1, value2, value3. ValueN represents the value in the list.

MySQL compares the values of expr to the values in the list one by one.

two。 The difference between the two:

SELECT DISTINCT from_id FROM table_codWHERE cod.from_id NOT IN (37, 56, 57)

Null will be excluded from not in.

Having null in in query does not affect the result.

Thank you for reading! This is the end of this article on "how to use IN and NOT IN in MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!