Resolving MySQL Error – FUNCTION CONCAT does not exist

January 8th, 2013 - Posted by Steve Marks to MySQL, Web Development.

Before I begin it’s worth nothing that this error is only a problem on certain versions of MySQL. The error in question is as follows:

[Err] 1305 - FUNCTION databasename.CONCAT does not exist

Let’s take a look at a very simple query that would result in this error appearing:

SELECT CONCAT ('foo', 'bar')

The Solution

The solution is an easy one. Simply remove the space after the word CONCAT. I’ve included below a revised (and working) version of the query from above.

SELECT CONCAT('foo', 'bar')

This entry was posted on Tuesday, January 8th, 2013 at 5:32 pm by +Steve Marks and is filed under MySQL, Web Development. You can follow any responses to this entry through the RSS 2.0 feed.

Fear not, we won't publish this

Comments (3)
  1. I think you’re spelling the function wrong. Should be GROUP_CONCAT(), not GROUP_CONTACT()

  2. Anonymous says:

    SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id=’1′ AND section_id=’61’ AND assignment_date=’2015-06-30′ GROUP BY subject;
    For above query , I am facing this error , what is the mistake,
    #1305 – FUNCTION ssv.GROUP_CONTACT does not exist.

  3. enof says:

    finally an answer that works
    (but dont ask me why)
    thanks Steve Marks