Using QGIS 3.10 I need to select all points that have the word fium and its variace like fiume, fiumara, FIUME, etc. The name of field is toponimo, I've used this query:

"toponimo" = '%fium%'

But I've zero results and this is not correct because I see a lot of rows that have this information.

What is the right way to solve my problem?

  • 3
    Have you tried "toponimo" Like '%fium%'?
    – ahmadhanb
    Oct 4 '20 at 11:55
  • regex is also an option.
    – Al rl
    Oct 4 '20 at 14:35

The right expression should "toponimo" Like '%fium%' for searching using wildcard. You can refer to the documentation for more information. If you want to search for wildcard using case sensitive, you need to use Ilike.

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.