QGIS Filtering Multiple Values using Query Builder

Question

In the "Query Builder" I can currently filter on value from the "Values List", but I'd like to be able to filter for multiple values at once.

How can I go about doing this using the SQL and "Operator's Section"?

PolyGeo · Accepted Answer · 2023-05-24 19:27:08Z

45

One method is to use the IN function followed by your list of values all inside brackets.

E.g.

"Column_Name" IN ('Value_1', 'Value_2', 'Value_N')

PolyGeo♦

65.5k29 gold badges115 silver badges353 bronze badges

answered Aug 25, 2015 at 13:19

Joseph

76.7k8 gold badges173 silver badges286 bronze badges

HeikkiVesanto · Accepted Answer · 2017-01-03 09:54:31Z

10

The alternative is to use an AND/OR statement:

"Column_Name" = 'Value_1' OR "Column_Name" =  'Value_2'

answered Aug 25, 2015 at 13:27

HeikkiVesanto♦

17.1k3 gold badges49 silver badges82 bronze badges

2 Answers 2