In QGIS is there a way to filter a layer using the Query Builder to show all values which include a particular phrase. For example I have a list of organisations and I want to filter all those which include the word Wales. I can do this using the attribute table but not in the map view so that the map just shows these selected features.


Use "LIKE" with percentages.

In my shapefile of countries I can select any country with a name like "This and that" with:

"CNTRY_NAME" LIKE '% and %'

this selects only "Bosnia and Herzegovina". If I remove the spaces:


I get Iceland, England and all the others with "and" in them.

That all works for shapefiles - the help for the query builder mentions that the syntax and behaviour may depend on your data source.

  • That's just what I needed. Thank you so much Spacedman!! – user34823 Aug 1 '14 at 20:03
  • Could you tick the little tick next to my answer to show that this question has now been answered? – Spacedman Aug 3 '14 at 22:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.