CONCAT
CONCAT(s1, s2) | ||
---|---|---|
Engine | OK | Alternative |
ingres | Yes | |
mysql | Yes | |
oracle | No | s1 || s2 |
postgres | No | s1 || s2 |
sqlserver | No | s1 + s2 |
CONCAT
CONCAT allows you to stick two or more strings together.
This operation is concatenation.
CONCAT(s1, s2 ...)
In this example you put the region and the name together for each country.
SELECT region || name
FROM bbc
SELECT region + name
FROM bbc
SELECT CONCAT(region,name)
FROM bbc
See also
Language: | English • Deutsch |
---|