I'm really stuck on something which is probably really easy...so apologies in advance!
I have a column which can contain any of the following for instance:
or a set of values with pipe delimiters
Thin||Super Thin||Other Value||Another Value
I want to select only occurrences of Thin but not Super Thin
I've tried LIKE AND NOT LIKE but this doesn't seem to work:
SELECT value FROM table_name WHERE value LIKE "%Thin%" AND value NOT LIKE "%Super Thin%"
Also looked into REGEXP but not sure how to use in this case.