Re: Adding to a Field

[David Shrewsbury]

If you have a unique key in the table, you can use INSERT ... ON DUPLICATE KEY to handle both new rows and updating of existing rows:

INSERT INTO Player1 (id, Test1) VALUES (id, '5,')
ON DUPLICATE KEY UPDATE Test1 = CONCAT(Test1, '5,');

-Dave