How can individual values be deleted from a concatenated string in a database field using PHP?

To delete individual values from a concatenated string in a database field using PHP, you can retrieve the concatenated string from the database, split it into an array using a delimiter (such as a comma), remove the unwanted value from the array, and then concatenate the remaining values back into a string to update the database field. 

// Retrieve concatenated string from the database
$concatenatedString = "value1,value2,value3,value4";

// Split the string into an array using a delimiter
$array = explode(",", $concatenatedString);

// Remove the unwanted value (e.g. value3)
$unwantedValue = "value3";
$key = array_search($unwantedValue, $array);
if ($key !== false) {
    unset($array[$key]);
}

// Concatenate the remaining values back into a string
$newConcatenatedString = implode(",", $array);

// Update the database field with the new concatenated string
// $newConcatenatedString can be inserted or updated in the database field

Keywords

PHP string manipulation database SQL DELETE statement

Related Questions