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 );
Online trading has brought ease of trading, better security protocols, and fast trade executions; however,…
Very few brands suffer from a product issue. It's a conversion issue. People enter DMart,…
The onboarding process of the retailer, distributor, or partner may soon become problematic if there…
Many of the states in the United States of America allow the use of medical…
Did you know that every time you browse this website or any other, you leave…
Online casino has gained immense popularity with the rise of online casinos. Platforms like GameZone…