I'm using QGIS and I am trying to filter a dataset using the advanced filter. My dataset contains earthquakes in the U.S., Canada and Mexico, however I would like to exclude Canada & Mexico for now.
The problem arises when I filter using:
"place" LIKE '%Mexico%'
as this now includes Mexico AND New Mexico.
I've been trying to experiment with SQL commands but I've had no luck so far.