Please use the "IN" operador

It’s not the first time I see people that, to select feature by their fields values, use expressions like this:

[code language=“SQL”]“field” = ‘value1’ OR “field” = ‘value2’ OR “field” = ‘value3’ [OR …][/code]

A more practical and pretty way of doing this is by using the IN operator instead.

[code language=“SQL”]“field” IN (‘value1’,‘value2’,‘value3’[,…])[/code]

This operator is available in almost every GIS software I know. In QGIS, it can be used even if there isn’t a small little button to click.

In fact, this is an abbreviation of what is used in SQL, where the operator is used in the WHERE statement:

[code language=“SQL”] SELECT * FROM parks WHERE “tipo” IN (‘PI’,‘CM’,‘PJ’); [/code]