I know I know..
for sure one of the easier mysql statements. But somehow I can not figure out this.

I expect to see all distinct items of 'data_12' where 'kwroot' has 'straxx' in, and in the same row 'data_12' ist (not = 'kwsearched' in any existing row)

Code:

data_12                   kwroot        kwsearched 
straxx password           straxx          straxx
xxxx                     yyy            straxx password

Code:

SELECT data_12, kwroot, kwsearched
FROM sc
WHERE kwroot LIKE 'straxx'
AND (data_12 NOT like kwsearched)
GROUP BY data_12

Result:

Code:

data_12                   kwroot        kwsearched 
straxx password        straxx          straxx

I see this statement works correct, but how can I tell him to check that "AND (data_12 NOT like kwsearched)"<== but also not in whole 'kwsearched'??

I expect the result to be empty