MySQL NOT IN Operator

The MySQL NOT IN Operator does the exact opposite of the MySQL IN Operator. The NOT IN operator checks if a value is not present in a set of values and returns those values. Suppose you are a boarding school administrator and you want to know which of your students are not from Pune or …

MySQL NOT IN Operator Read More »

MySQL IN Operator

Suppose you are a boarding school administrator and you want to know which of your students are from Pune, Nagpur, and Mumbai from an SQL table. You can always use multiple OR operators but there is another, more effective way. We are looking at students in Pune, Nagpur, and Mumbai. And MySQL, like the beautiful …

MySQL IN Operator Read More »