Concatenating Character Strings in MySQL

Q

How To Concatenate Two Character Strings in MySQL?

✍: FYIcenter.com

A

If you want concatenate multiple character strings into one, you need to use the CONCAT() function. Here are some good examples:

SELECT CONCAT('Welcome',' to') FROM DUAL;
   Welcome to

SELECT CONCAT('FYI','center','.com') FROM DUAL;
   FYIcenter.com

 

⇒Introduction to SQL Basics in MySQL

⇒⇒MySQL Database Tutorials

2016-10-17, 186👍, 0💬

General MySQL Oracle SQL Server