MySQL - Concatenating Character Strings in MySQL

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

2018-04-07, 310👍, 0💬

Popular Posts:

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

Transaction Manageme...

Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...

AdventureWorksLT - D...

How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...

Conditional Statemen...

Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...