Geek Answers Handbook

GROUP CONCAT does not work for any reason

I generate a select statement and get this error.

FUNCTION GROUP_CONCAT does not exist. Check "Function Name Designation" and "Resolution" in the Reference Guide

I do not understand this, because the concats group worked with the code that someone gave me, from which I built my new code. Here is what it looks like

SELECT `shirts`.`shirt_name`, `shirts`.`men` AS `main_photo`, GROUP_CONCAT (`shirt_sizes`.`size_name`) AS `sizes` FROM `shirts` JOIN `shirts_link` ON `shirts_link`.`shirt_id`=`shirts`.`id` JOIN `shirt_sizes` ON `shirt_sizes`.`id`=`shirts_link`.`size_id` JOIN `shirt_prices` ON `shirt_prices`.`id`=`shirts_link`.`price_id` WHERE `men`!='' GROUP BY `shirt_prices`.`price_cat`

Can anybody help?

+6
source share
1 answer

There should be no spaces between the function name and parentheses. The change

 GROUP_CONCAT (`shirt_sizes`.`size_name`) AS `sizes`

to

 GROUP_CONCAT(`shirt_sizes`.`size_name`) AS `sizes`
+20
source

More articles:


All Articles