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?