Chapter 2: Queries: Selecting Data from a Table

Using not like

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, you can use either of these queries:

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

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

Getting different results using not like and ^

View this book as PDF