Newbie question... add to string field??

[shawjames]

stupid question here, but I just cant figure it out!

cell has a sting, and I want to add to the end of it.

update my_db set testName = testName + "more info" where id=123

So basically, I want to add to a cell value. I know this works with numbers... but how do you do it with strings?

Thanks!

[LordShryku]

Look up "concat" in the manual

[Sxooter]

Note, the SQL spec says you do it this way:

update table set oldfield=oldfield||'more text here';

MySQL insists on using || as an or operator (unless you've turned on the -ansi switch that is) so you have to use the non-standard concat() function.

Just in case you're using a different database. You didn't say, after all.