not like Usage

You can use the same wildcard characters with not like that you can use with like.

For example, to find all the phone numbers in the authors table that do not have 415 as the area code, use either of these queries:

select phone 
from authors 
where phone not like "415%"

select phone 
from authors 
where not phone like "415%"