[SOLVED] attaching string

[asmith]

hey guys

 

can i attach a string to a field ? 

 

update table set id=id+3 ...

 

the code above add 3 to whateer id number is . 

now if i have a varchar field , can attach some sentence to it ?

 

like if the field name is "john" , i attach "smith" at the end of it . something like :

 

update table set name=name+"smith"    //   add it to the end of the string 

 

how should it be ?

[drranch]

It sounds like you are trying to "concatenate" two strings together...

 

UPDATE table SET name=concat(name, smith)

 

 

 

[asmith]

thank you , that was the thing i was looking for .