[SOLVED] Add Data to exist field

[FD_F]

i have for example field called : SharedWith

and he has value 1

 

i want add  value 56,  there is any way in update sql syntax  to add and not erase all the field ?

 

the result shuld be 1,56

now when i using UPDATE he erase 1 and put only 56

 

thanks

 

[dzelenika]

UPDATE table SET SharedWidth = CONCAT_WS(',',SharedWidth, '56') ...

Of course SharedWidth should be text(not numeric) type.

But why you want to do this. I'm sure there's better solution.

[FD_F]

thanks works perfect

[fenway]

thanks works perfect

Please use a where clause!