Search for a word in FAT with QGIS

Question

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?

ahmadhanb · Accepted Answer

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.

Search for a word in FAT with QGIS

One Answer

Add your own answers!

Ask a Question