Resolving MySQL Error – FUNCTION CONCAT does not exist

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')