How To Concatenate Two Character Strings? | MySQL Interview Questions

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(bdb’,’center’,’.com’) FROM DUAL; 
blosumsdotnet.blogspot.com