I have a data extension with a level field based on the subscription level of customers. The fieldcontains 4 options, beginner, intermediate, expert and when they choose nothing it is unspecified(BLANK), it doesn't show anything.
I'm trying to get the beginner field and unspecified only
So far, I've tried
WHERE l.Level NOT like '%intermediate%' AND l.Level NOT like '%expert%'
but that only gives me the beginner customers and I also need the ones that have the status unspecified.
I'm trying to use regexp but I'm not confident with the syntax and I get an error
WHERE l.level not like REGEXP '^[^intermediate]' AND l.level not like REGEXP '^[^expert]'