I have a vector layer: ROADS that is composed of different types of roads: primary, secondary, tertiary, trunk, etc.
When I right click on the layer ROADS and I go to Attribute table -> Select by expression -> the column where I want to do the selection: highway -> I wrote this:
"highway" ILIKE '%primary%' OR "highway" ILIKE '%secondary%' OR "highway" ILIKE '%tertiary%' OR "highway" ILIKE '%trunk%' NOT "highway" ILIKE '%trunk_link%'
Till NOT "highway" ILIKE '%trunk_link%'
the selection is working well. I can see all the roads that starts with primary, secondary, tertiary and trunk. So also trunk_link -> I don't want that. To erase it from the selection I add NOT "highway" ILIKE '%trunk_link%'
. It didn't work -> suddenly I had O selected lines .
Do anyone knows the solution to my problem?