Appending

[Guest_imported]

Is there a way to append a field in SQL? I'm looking for something sort of like Perl's open(FILE,">>file.txt" where I can just add to the end of a field rather than doing a SELECT and then overwriting the field with an UPDATE.

 

[piti]

try this

UPDATE MyTbl SET Field = CONCAT(IFNULL(Field, \'\'), 'newdata') WHERE IdField=id