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"?

Answer 1

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')

Hope this helps!

Answer 2

The alternative is to use an AND/OR statement:

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