sql where multiple values
snippet in sql

sql where multiple values

user8890

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...); 

sql field equals multiple values

user1858

SELECT ads.*, location.county 
FROM ads
LEFT JOIN location ON location.county = ads.county_id
WHERE ads.published = 1 
AND ads.type = 13
AND ads.county_id IN (2, 5, 7, 9)

in condition in sql

user9091

IN condition allows you to easily test
if an expression matches any value
in a list of values.
It is for reducing  multiple OR
conditions in a SELECT, INSERT, 
UPDATE, or DELETE statement.

sql query with multiple where conditions

user4451

+----+----------+----------+
| ID | NAME     | SALARY   |
+----+----------+----------+
|  3 | kaushik  |  2000.00 |
|  4 | Chaitali |  6500.00 |
|  5 | Hardik   |  8500.00 |
|  6 | Komal    |  4500.00 |
|  7 | Muffy    | 10000.00 |
+----+----------+----------+