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 );
Introduction There is an increasing need for full-stack developers because companies want people who can…
Classic Russian literature holds a quiet power that still shapes stories today. Its voice feels…
Digital channels often get most of the attention in modern branding. A business can launch…
If you have been researching digital marketing programs in India, Kraftshala and IIDE both keep…
Email marketing remains one of the highest-performing digital marketing channels because it gives businesses direct…
Pain in muscles and joints can be a problem in everyday life, whether it involves…