Append Data to Field in MySql


/ Published in: MySQL
Save to your folder(s)

Notice the space in the appended portion, otherwise you just tack right on with no separation.
If your original value is null you can use this:
CONCAT(IFNULL(email_data, ''),' $email_data')
This will add it on to a null value as the first value in the entry

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.