I have a table like this:
id | value1 | value2
-------------------------
1 | a,b,c,d | a,d,e,f
-------------------------
2 | d,e,f,a |
-------------------------
3 | a,x,y,z | d,e,f
How can I get all rows that have "a" in [value1] but don't have "a" in [value2]? It should be this:
2 | d,e,f,a |
-------------------------
3 | a,x,y,z | d,e,f
Thanks in advance!