[RESOLVED] Append to db value

[richie]

I have a db table with a varchar column that needs updating.

When I issue this command:

update chamber set category=category+', Restaurants' where companyName='Beach Nights'

The updated value becomes 0.

In other words, mysql is performing a mathematical calculation on the row.

What I really want is for mysql to append more data to the existing data.

Thx.

[richie]

Oh, never mind, I found the answer.

update chamber set category=concat(category,', Restaurants') where companyName='Beach Nights'