Rutas en: Comala (2), Colima (3), Cuauhtemoc (1), Villa de Alvarez (3), Armería (1), Tecomán (1), Coquimatlán (1), Manzanillo (2), Minatitlán (1), Mazamitla (1), Cihuatlán (1)Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'like'

---

select * from prutas where activo=1 and (municipio like '%Tecomán%') and tipo='turismo' limit 0,100