SQL

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'
"

updating 2 values in a same colum mysql

If we want to swap the values of m->f and m->f
Using the if condition
Update Salary
Set sex = if(sex ='m','f','m');