Update concat text with null value in mysql

by Jayanthi 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

Tagged in:

888
like
4
dislike
4
mail
flag

You must LOGIN to add comments