Skip to main content
Geographic Information Systems

Return to Question

Title changed, Content Structured
Source Link
Taras ♦
Taras ♦
  • 34k
  • 4
  • 73
  • 148

Selecting features based on a great number of different values in the attribute table in QGISAttribute 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 + ORLIKE/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'ILIKE'-way: "city" ILIKE 'Paris' or "city" ILIKE 'Rome' or "city" ILIKE 'Berlin' or "city" ILIKE 'Moscow'

"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''Paris' OR 'Rome' or 'Berlin' or 'Moscow' in the "city""city" field doesn't seem to work.

Thank you!

Selecting features based on a great number of different values in the attribute table in QGIS

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.

Thank you!

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.

Source Link
Philippe Morgan
Philippe Morgan
  • 633
  • 4
  • 11

Selecting features based on a great number of different values in the attribute table in QGIS

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.

Thank you!