MySQL query to get total from each distinct initial letter from a dictionary database, with special cases like suffix (-grafia, -inho)

initials_from_dictionary.sql

-- MySQL query to get total from each distinct initial letter from a dictionary database, with special cases like suffix (-grafia, -inho)
-- Fields: dic_word, DB: nuke_dictionary
--

SELECT 
	IF(
		SUBSTRING( dic_word, 1, 1 ) IN ('&', '-'), 
		SUBSTRING( dic_word, 2, 1 ), 
		SUBSTRING( dic_word, 1, 1 )
	) AS inicial
, COUNT(*) AS total
FROM nuke_dictionary WHERE 1 
GROUP BY inicial
ORDER BY inicial