El operador LIKE utiliza como comodines '%' y no '*'
Prueba esto
Código SQL:
Ver originalSELECT COUNT (codesbycontry) AS codes, reference, avg(price) AS promedio FROM internationalrates WHERE codesbycontry LIKE '%Unicom%' OR reference LIKE '%Unicom%' OR price LIKE '%Unicom%' GROUP BY reference ORDER BY Reference ASC