you are at Encyclopedia of SQL >> CONCAT
CONCAT()
With CONCAT() we are able to concatenate two or more text strings.
Syntax of concatenation operator is different in databases :
Oracle: CONCAT() or ||
MySQL: CONCAT()
SQL Server: +
Syntax for MySQL/Oracle
SELECT CONCAT(`column_name1`,`column_name2`)
FROM `people`
Example for CONCAT()
Display concatenation of name and surname
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
query
SELECT CONCAT(`name`,`surname`)
FROM `people`
result
| CONCAT(`name`,`surname`) |
|---|
| PawełKowalski |
| PiotrJanik |
| MichałNowak |
In Oracle CONCAT() function we can provide only 2 parameters.
This problem is to omit with using Oracle operator || .
Syntax for using operator || in Oracle
SELECT 'example_text'||column_name1||'example_text'||
column_name2
FROM `table_name`
Example for using || in Oracle
Display name and surname separated with space bar (" ")
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
SELECT name||' '||surname FROM `people`
result
Paweł Kowalski
Piotr Janik
Michał Nowak
Syntax for SQL Server
SELECT 'example_text'+column_name1+'example_text'+
column_name2
FROM `table_name`
Example for using + in SQL Server
Display name and surname separated with space bar (" ")
| name | surname | age |
|---|---|---|
| Paweł | Kowalski | 3 |
| Piotr | Janik | 7 |
| Michał | Nowak | 13 |
SELECT name+' '+surname FROM `people`
result
Paweł Kowalski
Piotr Janik
Michał Nowak
[ wróć na górę strony ]
