Update field value with another field value within same table
update food_food set total_carbs = IF(total_carbs is NULL or total_carbs='',sugars,total_carbs) ;
update food_food set total_carbs = IF(total_carbs is NULL or total_carbs='',sugars,total_carbs) ;
Comments
Comments powered by Disqus