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.