How to concatenate more than 2 fields with SQL?

Question

I am trying to use CONCAT with SQL to concatenate 3 fields, and get the following error:

Incorrect parameters in the call to native function 'CONCAT'

The query is as follows

SELECT CONCAT(guests.lastname,', ',guests.firstname', ',guests.passport) AS display 
  FROM guests 
 WHERE guests.uuid = '1'

How do you concatenate more than 2 fields in SQL?

score 31 · Accepted Answer · answered Jul 05 '10 at 22:55

31

You must put commas between all the arguments.

Change:

 SELECT CONCAT(guests.lastname,', ',guests.firstname', ',guests.passport)

to:

 SELECT CONCAT(guests.lastname,', ',guests.firstname,', ',guests.passport) 
                                                    ^

answered Jul 05 '10 at 22:55

Mark Byers

I've found that Doctrine only accepts two arguments for its CONCAT function. http://www.doctrine-project.org/jira/browse/DDC-670 Not a simple syntax error in my case. Work around being expressing it like: `CONCAT(a, CONCAT(b, CONCAT(c, d)))` – ficuscr Aug 18 '14 at 17:18

score 3 · Answer 2 · edited Sep 13 '19 at 07:31

3

SELECT CONCAT(guests.lastname,', ',guests.firstname', ',guests.passport) AS display 
FROM guests 
WHERE guests.uuid = '1'

Kindly try the below one,

SELECT guests.lastname||','||guests.firstname||','|| guests.passport AS display 
  FROM guests 
 WHERE guests.uuid = '1'

edited Sep 13 '19 at 07:31

Ramprasath Selvam

answered Sep 13 '19 at 07:03

Praveen Kumar C

score 2 · Answer 3 · edited Sep 16 '17 at 12:29

2

SELECT CONCAT(guests.lastname,concat(', ',concat(guests.firstname,concat(', ',guests.passport))));

edited Sep 16 '17 at 12:29

rene

answered Sep 16 '17 at 12:26

3 Answers3