9

I want to filter out some bits of a layer and I want to do this in Query builder in the on a text field which contains names of several countries. I cannot figure the use of "IN" as in I want to find 'India' or 'China' or 'Bhutan' in field "Territory." Seems like it should be easy, but I'm just stupid today.

Improve this question
1
  • Don't worry, everyone has bad days. It doesn't make you stupid :) – Joseph Sep 28 '16 at 11:51
19

You could use something like:

"Territory" IN ('India', 'China', 'Bhutan')
Improve this answer
5
  • 2
    See here about SQL IN operator: w3schools.com/sql/sql_in.asp – wiltomap Sep 22 '16 at 13:32
  • This question is not really about GIS stuff. It should rather be posted on other SE sites such as Stackoverflow or Database Administrators. – wiltomap Sep 22 '16 at 13:34
  • 2
    @wiltomap Isn't still highly relevant to GIS users? – Victor Sep 22 '16 at 14:16
  • @wiltomap that's only the case if the user is aware that QGIS query builder uses standard SQL syntax in this case – underdark♦ Sep 22 '16 at 15:54
  • Definitely a useful answer, as not all GIS users are into the database side – Shawn Jan 1 at 19:04

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.