HELP with SQL WHERE syntax
As Martin Smith and dezso commented, you can add parentheses to your query to be explicit in your intent since they can change how the where clause is evaluated:

SELECT DISTINCT ID AS IDs
FROM DBTABLE
WHERE ((ID = 1423) AND (Tags LIKE '%Warm%'))
OR ((ID = 2743) AND (Tags LIKE '%Dry%'))
OR ((ID = 4832) AND (Tags LIKE '%Cool%'))


This returns a 3-record result set containing 1423, 2743 &amp; 4832 from your example data.

Parentheses can also make your SQL queries more readable and maintainable.