Using IN operator in MySQL you can match the value from a set of values or a subquery.
SELECT * FROM user WHERE country IN ('IN','AUS'); Here both the user from IN and AUS will be shown in the result.
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 );
The coronavirus outbreak has drastically changed the way we live our lives. Yes, that's absolutely…
Sales and marketing teams help attract, convert, and retain customers to ensure an organization’s long-term…
Are you an owner of a small business who’s trying to come up with ways…
Introduction When patients bring me their lab reports, the confusion is almost always the same.…
Are you excited about remodeling your house after a long time? Perhaps if you're planning…
The practice of yoga teaches us to be present, patient and mindful of our decisions.…