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.
