how to update a column with multiple values in mysql code example
Example 1: mysql update multiple rows with different values
UPDATE config
SET config_value = CASE config_name
WHEN 'name1' THEN 'value'
WHEN 'name2' THEN 'value2'
ELSE config_value
END
WHERE config_name IN('name1', 'name2');
Example 2: mysql updating multiple column values from array variable
"UPDATE product_list
set
product_name='$product_name',
product_category ='$product_category',
product_price='$product_price',
product_description='$product_description',
product_size_category='$size_category'
where product_id='$product_id'
"