UPDATE foodservice_recipes SET ingredients=(SELECT GROUP_CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(amount,' '),item),' '),quantity)) AS ingredients FROM foodservice_ingredients WHERE recipe_id=1) WHERE id=1;