SQL Tutorial

SQL CONCAT Function

SQL CONCAT() function is used to concatenate two or more strings. MySQL allows you concatenate more than two strings while other force exactly two. here is the syntax:

	CONCAT(expression)

Here is query to concat employee name and his salary in MySQL:

SELECT CONCAT(name,':',salary) as name_salary
FROM employees

Here is the output:

name_salary     
----------------
jack:3000.00    
mary:2500.00    
newcomer:2000.00
anna:2800.00    
Tom:2700.00     
foo:4700.00
Read On