Page 1 of 1

append to end of field

Posted: Fri Oct 07, 2005 6:25 am
by shiznatix
i have a field with numbers like 43,135,3,1

i want to update that field to 43,135,3,1,65 so it will just add to the end.

how do i do this in 1 query?

Posted: Fri Oct 07, 2005 6:34 am
by n00b Saibot

Code: Select all

UPDATE `table` SET `field` = CONCAT(`field`, ',$data')

Posted: Fri Oct 07, 2005 7:38 am
by shiznatix
thanks pimp