What MySQL statement?

[Anon]

Is there a way to add data to an existing field without overwriting its contents?

ie: I've got a table in mysql with a list of ids in one field like:

|products|

|32,954, |

Now if I wanted to add 7, to products in table joesmith.. ie:

|products |

|32,954,7,|

Is there a way to do this without having to first select the current content, put it in a varaible, add it back into an UPDATE statement along with the new content...

Mark

[Anon]

As far as I know you have to:

first select the current content, put it in a variable, add it back into an UPDATE statement along with the new content...

regards

Rik