Keep adding into to same field

[gerrybytes]

Hi,

I was just wondering is it possible in mysql to keeping adding info to a particular field.

I thought maybe the update query would work but that clears and previous data held in that field and all I want to do is add to it.

Thanks

G

[ronverdonk]

Hi,

I was just wondering is it possible in mysql to keeping adding info to a particular field.

I thought maybe the update query would work but that clears and previous data held in that field and all I want to do is add to it.

Thanks
G

Use the CONCAT() function in your SET attribute. Like[code=sql]UPDATE tbl_name SET field=CONCAT(fi eld, 'XXX');[/code]Ronald

[gerrybytes]

Use the CONCAT() function in your SET attribute. Like[code=sql]UPDATE tbl_name SET field=CONCAT(fi eld, 'XXX');[/code]Ronald

Thanks Ronald,

You have been of great help.

G

[ronverdonk]

Thanks Ronald,

You have been of great help.

G

You are welcome any tme. See you around.

Ronald