Create a histogram of UUIDs by their first character
SELECT LEFT(`assetuuid`,1) as `ST`, count(*) as `CNT` FROM `tex` GROUP BY `ST`