mysql update sintax

[Anon]

I\'m trying to update afield of a table, but I dont want to replace the old value. I want to put them together (concatenate them)

like, if \'field\' has value \'a 0 l o k l p\' and I want to add \' a120000ad \' to make it become \'a 0 l o k l p a120000ad \'

I\'ve tried + but it only seams to add numeric values (like UPDATE table SET field = field + 1)

[brandonschnell]

UPDATE table SET field = CONCAT(field,' a120000ad ');

[Anon]

I have already found it out, bu thanks for your help anyways.