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