php - Mysql Group_concat 又在哪里 group concat 我该如何管理

Question

当我运行此查询结果时

SELECT 
    GROUP_CONCAT(`recipe_ingredient`.`recipeId`) 
FROM `recipe_ingredient` 
WHERE `recipe_ingredient`.`ingredientId` 
    IN(4,11,33,36,54,117,135,136,178,185,218,312,348,378)
ORDER BY `recipeId` ASC  

<小时/>

但我想要从其他表获取上述查询“IN”值，因此我正在创建新查询，但我没有得到结果

在此处查看下面的新查询

SELECT 
    GROUP_CONCAT(`recipe_ingredient`.`recipeId`) 
FROM `recipe_ingredient` 
WHERE `recipe_ingredient`.`ingredientId` 
    IN(
        SELECT 
        GROUP_CONCAT(`ingredient`.`ingredientId` 
        ORDER BY `ingredient`.`ingredientId` ASC ) AS unlinkIng 
        FROM `ingredient` 
        WHERE `ingredient`.`ingredientId` IN(4,178) or    `ingredient`.`linkIngredientPerent` IN(4,178)
)
ORDER BY `recipeId` ASC  

Answer 1

从子查询中删除GROUP_CONCAT:

SELECT 
    GROUP_CONCAT(`recipe_ingredient`.`recipeId`) 
FROM 
    `recipe_ingredient` 
WHERE 
    `recipe_ingredient`.`ingredientId` IN (SELECT `ingredient`.`ingredientId` AS unlinkIng 
                                           FROM `ingredient` 
                                           WHERE `ingredient`.`ingredientId` IN (4, 178) 
                                              OR `ingredient`.`linkIngredientPerent` IN (4, 178))
ORDER BY 
    `recipeId` ASC  

<小时/>