SELECT *,SUBSTRING(cod, 1, 1) AS cod_ord FROM `oggetti` ORDER BY cod_ord ASC, ordinamento DESC