How To Concatenate Two Character Strings

Q

How To Concatenate Two Character Strings? - MySQL FAQs - Introduction to SQL Basics

✍: 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

2007-05-11, 9766👍, 0💬