CONCAT

From SQLZoo
Jump to navigation Jump to search
Compatibility
CONCAT(s1, s2)
EngineOKAlternative
ingresYes
mysqlYes
oracleNos1 || s2
postgresNos1 || s2
sqlserverNos1 + 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:Project:Language policy English  • Deutsch
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects