mysql explode data count

Mon Sep 18 2023 19:14:58 GMT+0000 (Coordinated Universal Time)

Saved by @raca12

SELECT SUBSTRING_INDEX(promosyon_kod, '-', 1) promosyon_kod FROM promosyon group by SUBSTRING_INDEX(promosyon_kod, '-', 1)