I have a punctual shapefile containing the name of geographic locations (attribute 'name')
Using DB Manager of Qgis, I would like create an SQL query to find, within the shape, the name of a location and, and therefore its point. I would like to find the name of the location even by writing only one part.
For example: The name of location is 'Torretta'. Just writing "Torr", I would like to find all the locations that contain the word "Torr" (without considering the upper case and lower case letters).