mySQL concat strings

[chick3n]

Is there a way in the UPDATE command to use a current fields string and add to it.

Not mathematically, but add a string to the end of it.

Field: name = '1,2,3,4'
i want to UPDATE table SET name=name . ',5'

so name will than be '1,2,3,4,5'
is that possible?

[ultraslacker]

You can use CONCAT(), but I wouldn't recommend storing multiple values in a column.