Answers for "check 2 values in where clause"

SQL
1

sql where multiple values

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
Posted by: Guest on July-29-2020
0

sql field equals multiple values

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)
Posted by: Guest on November-18-2020

Code answers related to "check 2 values in where clause"

Code answers related to "SQL"

Browse Popular Code Answers by Language