advanced code snippet search

Posted By

kidmizere on 03/26/11


Tagged


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

uberdragon
jeremydouglass


Append Data to Field in MySql

 / 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(emaildata, ''),' $emaildata') This will add it on to a null value as the first value in the entry

Expand | Embed | Plain Text 
  1. UPDATE tbl_NMR_users SET `tbl_NMR_users_FirstName` = CONCAT(`tbl_NMR_users_FirstName`,' TESTING') WHERE `tbl_NMR_users_RegNumber` = '156330';

Report this snippet  

You need to login to post a comment.