We can append datat to the existing data in mysql field. Column name is email and value is “info@smarttips.com” UPDATE `engine4_users` SET email = CONCAT( email, ‘_test’ ) After the query execution the _test dat will be appended to email Output:info@smarttips.com_test