Update concat text with null value in mysql

Question

trasaction table description field have some value it is worked fine. description feild default value is NULL,its not works..

update transaction set domain='hiox.com',description=CONACT(description,',domain swapped from hioxindia.com to hiox.com') where id=23602

help me..

juergen d · Accepted Answer · 2012-06-25 10:25:38Z

10

Use ifnull():

update `transaction` 
   set domain='hiox.com',
   description=CONCAT(ifnull(description, ''), ',domain swapped from hioxindia.com to hiox.com') 
where id=23602

Documentation

answered Jun 25, 2012 at 10:25

juergen d

205k40 gold badges304 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update concat text with null value in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related