I have a query of this kind:
SELECT cityname, countryname lat, lon
WHERE cityname LIKE ‘%Madrid%’
I would like to know: what’s the best way to optimize it (through an INDEX)? Because I think that wildcard at the first position creates some trouble.