Update/Insert - add to existing column value

[AHinMaine]

I've been searching through docs and at mysql.com but can't seem to find what I want.

I found this syntax:

UPDATE table SET c=c+1 WHERE a=1

What I want to do is prepend a string to a varchar column.

I tried:

update table set field2="insert"+field2 where field1 = "example";

which didn't work...
--
Andy

http://www.nachoz.com

 

[sleipnir214]

Try:

update table set field2=concat("insert",field2) where field1 = "example"; Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!