MySQL CONCAT () connection string detailed description

MySQL tutorial concat () connection string detailed description
In some cases you want two or more strings, in MySQL there is a string concatenation function concat (), let's talk about how it is used.

Concat syntax
Concat (STR1,STR2,...)

Simple instance two string connection

Select concat (' Hello ', ' world! ');

Of course you can use the fields in the table instead of the string constants, you can mix them. Let's look at a slightly more complex example. Assuming we have a name and age in a user table, now to be connected together, we can use the SELECT statement uses the concat

Select concat (Name, ' is ', age, ' years old. ') from user;

Bill is years old.
Mark is years old.
Julia is the years old.
Alex is years old.