Ii 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?

  • The select by expression uses its own non-SQL syntax – JGH Jun 1 at 12:07

You can achieve this task using arrays.

  1. Create an array with the search themes AND the placeholders
  2. for each value of the array, find if the name column contains it or not, using ilike
  3. as the output of step 2 is an array of true/false values, check if this output contains at least 1 true result
        ARRAY('%rom%','new yor%'),
        name ilike @element),
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.