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