Update that does not overwrite

[nathj]

Hi,

I have a field in a table that is type longtext. When a record is created there may or may not be anything that goes in here. However, it is possible for this field to be updated in such a way that I need to add any text to the end of what ever is already there.

I am familiar with the UPDATE syntax but I can only make this overwrite the information that is there. I need to add to the information that is there.

I could get the existing info into a variable and create a new variable with the original and the new information but I just thought it has to be possible to update a field without overwriting.

I found that with a numeric field it is possible to do something like:

update table set table.numericfield = table.muericfield+1 
 

Is it possible to achieve a similar affect with a text field?

Cheers
nathj

[code green]

You can try CONCAT.

UPDATE `table` SET `field` = CONCAT(`field`,'newdata')
WHERE condition

I think it can be used in an UPDATE query

[nathj]

You can try CONCAT.

UPDATE `table` SET `field` = CONCAT(`field`,'newdata')
WHERE condition

I think it can be used in an UPDATE query

Hi code green,

Thanks for that I'll give it a try.

Cheers
nathj