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?
append to end of field
Moderator: General Moderators
- n00b Saibot
- DevNet Resident
- Posts: 1452
- Joined: Fri Dec 24, 2004 2:59 am
- Location: Lucknow, UP, India
- Contact:
Code: Select all
UPDATE `table` SET `field` = CONCAT(`field`, ',$data')