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

 

Entering Numeric Values in MySQL

Escape Special Characters in MySQL

Introduction to SQL Basics in MySQL

⇑⇑ MySQL Database Tutorials

2018-04-07, 1381🔥, 0💬