Bug #2963 can't concatenate with +
Submitted: 25 Feb 2004 16:18 Modified: 1 Dec 2005 14:16
Reporter: Nathan Jensen Email Updates:
Status: Won't fix Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:4.1 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[25 Feb 2004 16:18] Nathan Jensen
Mysql seems to be unable to concatenate strings just by going:

SELECT 'Man' + ' ' + 'In The Moon'
--> Man In The Moon

I know about the CONCAT function, but it's a hassle, and the "plus-style" string concatenation is so common in so many languages.

I do hope you'll consider fixing mysql to support this syntax.

thanks you.

How to repeat:
see Description

Suggested fix:
see Descr.
[26 Feb 2004 10:08] Dean Ellis

[26 Feb 2004 10:09] Dean Ellis
Changed to a Feature Request... It's not a bug.  There is also support for the ANSI string concatenation operator (||) which you can enable if you wanted to use that.
[1 Dec 2005 14:16] Valeriy Kravchuk
I see no need to add yet another concatenation "operator". Use '||', as in many other RDBMS.