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?