At 16:45 -0600 3/20/04, Matt W wrote:
Hi Jim,
Unfortunately you do have to use the CONCAT() function to make sure it
works on all MySQL installations. The operator used in other DBs, and
which can be used in MySQL when running in ANSI mode, is ||, not +:
SELECT firstname || ' ' || lastname AS ful
t if MySQL isn't in ANSI mode (specifically, the PIPES_AS_CONCAT
part), which is typical since it's not enabled by default, || is logical
OR. :-(
Matt
- Original Message -
From: "Jim McAtee"
Sent: Thursday, March 18, 2004 4:29 PM
Subject: String Concatenation Operator
> or must you use the CONCAT() function?
Yes
SELECT concat(firstname,' ',lastname) AS fullname FROM customers;
Cheers,
Andrew
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 22:30
To: [EMAIL PROTECTED]
Subject: String Concatena
Does MySQL have a string contatenation operator, or must you use the
CONCAT() function?
SELECT firstname + ' ' + lastname AS fullname
FROM customers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]