GROUP CONCAT not working for some reason

mysql sql select group-concat
Optiq picture Optiq · Dec 31, 2012 · Viewed 8.1k times · Source

I'm forming a select statement and am getting this error.

FUNCTION GROUP_CONCAT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

I don't understand this because group concats worked with the code someone gave me that I built my new code from. Here's how it looks

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 someone please help?

Answer

AndreKR picture AndreKR · Dec 31, 2012

There must be no space between function name and parenthesis. Change

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

to

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

Related questions

SQL query return data from multiple tables

I would like to know the following: how to get data from multiple tables in my database? what types of methods are there to do this? what are joins and unions and how are they different from one another? When …

Read More
MySQL SELECT only not null values

Is it possible to do a select statement that takes only NOT NULL values? Right now I am using this: SELECT * FROM table And then I have to filter out the null values with a php loop. Is there a …

Read More
MySQL Select Query - Get only first 10 characters of a value

Ok, so here is the issue. I have a table with some columns and 'subject' is one of the columns. I need to get the first 10 letters from the 'subject' field no matter the 'subject' field contains a string with 100 …

Read More