Selecting objects based on multiple attributes QGIS

Question

I would like to select objects from the attribute table based on multiple attributes.

I want to select all ojects that have 'ja' in the column "BLAUWBORST", all objects that have 'ja' in the column "BRUINE_KIE", objects that have 'ja' in both of them and objects that have 'ja' in the column 'veertien' or 'vijftien' or...

Answer 1

Two options to archive this:

1. Simply connect your selection statements with a logic operator "OR" is the one you are looking for. The result is something like:

   "BLAUWBORST" = 'ja' OR "BRUINE_KIE" = 'ja' OR ... 
   

2. Use the Add to Selection button(image 1) when you write your selecting like this

   • "BLAUWBORST" = 'ja' -> Click "select"
   • "BRUINE_KIE" = 'ja' -> click on the arrow and click "Add to selection"

Answer 2

Came across this question looking for a slightly different answer, which is to select multiple values in the same column.

I found that rather than doing a whole bunch of 'OR' statements, QGIS (as of 3.10) supports the following syntax:

"<Column Name>" in ('<value 1>', 'value 2>') etc.