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 a world where digital presence is paramount, the question isn't whether you should do…
Over the years, people have experimented with various methods to maintain healthy and beautiful hair.…
Your brand more than developing an attractive and creative logo and infectious motto. It's the…
Introduction Are you someone who has suffered from a personal injury and want to file…
Operating from home has emerged as one of the most popular ways of doing jobs…
If the consequences of our society’s ever-growing debt are what worries you, then it is…