Categories
MySQL

MySQL IN Operator

MySQL SELECT
Share on Pinterest Share on LinkedIn Share on WhatsApp Share on Telegram

Using IN operator in MySQL you can match the value from a set of values or a subquery.

Example of MySQL IN:

SELECT * FROM user WHERE country IN ('IN','AUS');

Here both the user from IN and AUS will be shown in the result.

You may like:  Data Types - MySQL

You can also check for exception like:

SELECT * FROM user WHERE country NOT IN ('IN','AUS');

Here all the user will be displayed except IN and AUS.

You can also use a subquery:

SELECT * FROM user WHERE state IN ( SELECT state_id from STATE WHERE country = 221 );
Avatar for Namaste UI (Author)

By Namaste UI (Author)

Namaste UI collaborates closely with clients to develop tailored guest posting strategies that align with their unique goals and target audiences. Their commitment to delivering high-quality, niche-specific content ensures that each guest post not only meets but exceeds the expectations of both clients and the hosting platforms. Connect with us on social media for the latest updates on guest posting trends, outreach strategies, and digital marketing tips. For any types of guest posting services, contact us on info[at]namasteui.com.

Leave a Reply

Your email address will not be published. Required fields are marked *