how do i delete a value from comma separated column in mysql
is there any function to handle such operation?
You might be able to manage it with some LOCATE and SUBSTR calls in SQL, or by exploding, removing, and imploding in PHP. But there’s nothing I know of to do this directly. If it could be JSON instead of comma-separated, maybe? I haven’t used the native SQL JSON manipulation functions at all. Or, if it’s some kind of a list of associated records, please consider using a new table for the data: comma separated often looks like a nice easy solution at first, but will end up causing more headaches than it solves.