Select CONCAT(kindOfAnimal, '1')
from animal_table
group by kindOfAnimal;
This works?
solved Concat to field after query
 
Select CONCAT(kindOfAnimal, '1')
from animal_table
group by kindOfAnimal;
This works?
solved Concat to field after query