ALTER TABLE `user`   
  ADD `last name` VARCHAR(50)  
   AS (  
        case `name`  
        when admin then 0  
        else CONCAT(`name`, 'user')  
         end  
      )   
  ;