In Operator MySQL

mysql Share on :

Using IN operator you can check whether column values exist in a list of values or in records of a subquery.

-- Match with list values
SELECT 
    first_name, 
    last_name,
    city
FROM
    Students
WHERE
    city IN ('Delhi' , 'Newyork');


--Match with subquery records
SELECT    
	first_name, 
    last_name,
    city
FROM    
	Students
WHERE city IN
(
    SELECT 
        city
    FROM 
        city_list
);

You can also use the NOT IN operator to select records that do not exist in a set of values. The example MySQL query can be written as below.

SELECT 
    first_name, 
    last_name,
    city
FROM
    Students
WHERE
    city NOT IN ('Delhi' , 'Newyork');

Search Index Data (The code snippet can also be found with below search text)

Select records if exists in a set of values MySQL

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Create table with constraints MySQL query
Insert data into table mysql query
Get duplicate rows and its counts MySQL
Add foreign key in existing table Mysql
Order by ascending and descending MySQL
Get distinct records MySQL
Create and select database MySQL