Update string value in filed of database?

VestanPance

Greetings. I am needed to remove a certain "class" number from a field of classes separated by commas from MySQL. I know how to update fields but not when in a string like that. Any help on how to approach this one? Explanation below.

Field "Classes" has this value: [110,120,130,140]

-> remove "120"

Now field "Classes" has this value: [110,130,140]

Thanks. SP.

bpat1434

I'll have to double check (just read about this today) but I'm sure it's something like:

UPDATE table
SET Classes = TRIM(BOTH '120,' FROM Classes)

Not sure if that will work, but I do know you can do it in mySQL....

Roger_Ramjet

Brett, that is going to remove everything EXCEPT '120', not remove '120'.

What you need is REPLACE to replace the '120,' with an empty string ''


$sql = "UPDATE table SET classes = REPLACE(classes, '120,', '')";

bpat1434

Yeha... i hadn't gotten around to lookin it up... tried goin into mySQL documentation couldn't find it.. and I wasn't sure of REPLACE syntax... thanks for clearin it up...

I just read about it today... so I knew it could be done...

VestanPance

Perfect. Got it working just fine. Thanks for the help.