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 );
Modern web applications rarely live alone. A customer portal, an internal order-management console, or a…
An invoice lands in the accounts inbox for equipment delivered three weeks ago. The supplier…
A Google Ads management campaign can look healthy in the dashboard and still waste money…
A potential customer arrives on your website after searching for a service you provide. They…
In the business world, there’s no such thing as a new idea. The best we…
Both of these work. Both are difficult. And anyone telling you one is obviously better…