MySQL concatenation operator

Question

I don't know concatenation operator for MySQL.

I have tried this code for concatenation:

SELECT vend_name || ' (' || vend_country || ')' FROM Vendors ORDER BY vend_name; 

But it didn't work. Which operator should I use to concatenate strings?

Answer 1

|| is the ANSI standard string concatenation operator, supported by most databases (notably not MS SQL Server). MySQL also supports it, but you have to SET sql_mode='PIPES_AS_CONCAT'; or SET sql_mode='ANSI'; first.

Answer 2

You were using ORACLE type of concatenation. MySQL's Should be

 SELECT CONCAT(vend_name, '(', vend_country, ')') 

Call the CONCAT() function and separate your values with commas.