Appending Data

Apending Data using SQL query

[binarytrends]

I wonder if there is any way to APPEND data to an already populated field using a SQL query. I'm presently handeling it through PHP by writing two queries.

[killroy]

I suppose it would go like this:

UPDATE table SET field1=CONCAT(field1,' this will be appended to the end of field1') WHERE id=12345;

SN

[binarytrends]

Thanks killroy

[coopster]

That killroy supposes correctly quite often ;)

Welcome to WebmasterWorld, binarytrends.

[txbakers]

I always forget the CONCAT and try to do it with a simple ampersand and wonder why all my data disappears!

[binarytrends]

Hi Coopster, You must be right :)