I have to pull out a range of entries of a database, all based around two pieces of data. In itself thats fine. An example of the data is:
Record ID Tags 1 1423 Day, Sun, Warm 2 1423 Day, Sun, Wet 3 1742 Night, Warm 4 2743 Night, Warm, Dry, Stars 5 4832 Sunrise, Bright, Clear, Cool
Now in the above data, the ID is an internal company ID, but Record is a unique DB ID. There are 2,500 rows of similar data in the database, with other data thats not related to this query. Now we need to pull the data in the following style, written here in a symbolic, rather than specific SQL so people can understand it. Ive included brackets to emphasis which parts must match:
WHERE (ID=1423 AND tags contains Warm) OR WHERE (ID=2743 AND Tags contains Dry) OR WHERE (ID=4832 AND Tags contains Cold)
The question is how do I get the SQL statment to work right? I've tried
SELECT DISTINCT ID FROM DBTABLE WHERE ID=2743 AND Tags LIKE '%Warm%' OR ID=4832 AND Tags LIKE '%Cool%'
But it doesn't seem to return the correct records. I have a specific query which I know will return 5 records, but every time it returns more, including ones that don't match. I'm thinking the SQL is mixing up for example where ID=2743 AND (tags like warm or 2743) AND Tags like dry or 4832 etc...
Can anyone point me in the right direction. In essence it is multiple where statements, where each statement has to match an ID and have a 'LIKE' tag. but the statement can match one or more of the given WHERE statements. Does that make sense?