add prefix in table field in MySql

SET @rank:=0;
Update`employee` set email= CONCAT(@rank:=@rank+1,email) WHERE email='demo@mail.com'