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 );
In today’s fast-paced and highly competitive marketing environment, even the most creative campaign is only…
We are NYC moving firm. Are you planning a flat move? Maybe a distance or…
Mobile devices, unlike desktops and laptops, can not be handled by dozens or hundreds of…
Augmented Reality- An immersive experience for the learners! Learning and education aren’t the same as…
On special days like birthdays and weddings, we all like to celebrate our loved ones…
A web application is different from a regular mobile or desktop application as it runs…