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