sql condition can equal two values code example

Example 1: not equal operator sql

<> Not Equal

!= Not Equal

Example 2: 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)