Lusaunt Lusaunt - 1 year ago 82
MySQL Question

How to update a database record and still keep the old values in MySQL?

I want to update a column by adding a new value alongside the old ones. So if column "fruits" has a value of "apples" and I run my query it should then have a value of "apples, oranges".

Right now when I do an update statement"

UPDATE tableName SET fruits='oranges' WHERE id=1;

It just overwrites apples with oranges. How can I get it to ADD the new value alongside the old separated by commas?

Answer Source
UPDATE tableName SET fruits=CONCAT(fruits, ', oranges') WHERE id=1;


UPDATE tableName SET fruits=CONCAT_WS(', ', fruits, 'oranges') WHERE id=1;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download