/ Published in: MySQL
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
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
Expand |
Embed | Plain Text