I would like to select more features with expression in a specific field, which contains the name of the attribute (IN
operator is useful). Moreover, the name could not be exact, so the ILIKE
operator is necessary.
How can I match these 2 operators in one expression?
For example, I need to select 2 city called 'Rome' and 'New York'.
"city" in ('Rome','New York') -> selected both
"city" in ('rom','new yor') -> not selected
Any suggestion to select in the second case in QGIS?
Best Answer
You can achieve this task using arrays.
name
column contains it or not, usingilike