Skip to main content
2 of 2
Title changed, Content Structured
Taras
  • 34k
  • 4
  • 73
  • 148

Selecting features based on great number of different values in the Attribute Table

I have many land parcels related to many different cities. I would like to select land parcels related to some of these cities only (about 20 of them).

Is using LIKE/ILIKE + OR like below the only way to do this or is there a faster and more elegant way to do it when dealing?

'ILIKE'-way:

"city" ILIKE 'Paris' 
or
"city" ILIKE 'Rome' 
or
"city" ILIKE 'Berlin' 
or
"city" ILIKE 'Moscow'

Maybe in the form? But just writing 'Paris' OR 'Rome' or 'Berlin' or 'Moscow' in the "city" field doesn't seem to work.