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?

Accepted Answer

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.

MySQL concatenation operator

Solution

Problem

Related problems