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