Select - group by substr($stringa, 0, 7)

[marketto]

SELECT SUBSTRING(nomecampo,1,7) AS testo FROM tabella
GROUP BY testo