MySQL concatenating fields

Explain the use of Concat() functions. Provide an example to explain it.

Concat function is used to combine results from several different fields.

Syntax:
CONCAT(str1, str2, str3, ...):

Example:
SELECT CONCAT(employee_firstname,employee_lastname) FROM employee WHERE employee_salary > 1000;

Output:

John Payne
Mike Turner
MySQL text manipulation functions
MySQL text manipulation functions - left(), length(), locate(), lower(), LTRIM(), Right(), RTRIM(), Soundex(), Substring(), Upper()
MySQL date time manipulation functions
MySQL date time manipulation functions - AddDate(), AddTime(),CurDate(),CurTime(),Date(), DateDiff(), Date_Add(), Date_format()
MySQL numeric manipulation functions
MySQL numeric manipulation functions - Abs(), Cos(), Exp(), Rand(), Sin(), Sqrt(), Tan(), Mod(), Pi()
Post your comment

You may like