Update concat text with null value in mysql
by Jayanthi[ Edit ] 2012-10-04 10:16:10
Update concat text with null value in mysql
update `trans`
set domain='xxxxxx.com',
description=CONCAT(ifnull(description, ''), ',domain swapped from yyyy.com to xxxx.com')
where id=787567
