https://www.sqlines.com/ 2026-04-06T23:45:09+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2012-01-09T12:40:25+00:00 https://www.sqlines.com/mysql/functions/concat?rev=1326112825&do=diff CONCAT function concatenates 2 or more strings into one string. Syntax CONCAT(string1, string2, ...) Quick Example SELECT CONCAT('A','B'); Null If any value is NULL, the result is NULL Last Update: MySQL 5.6 Related Functionality in MySQL Related functionality for CONCAT in MySQL: text/html 2011-12-16T21:26:00+00:00 https://www.sqlines.com/mysql/functions/group_concat?rev=1324070760&do=diff GROUP_CONCAT function concatenates values within each group defined by GROUP BY clause. Syntax GROUP_CONCAT([DISTINCT] exp [ORDER BY sorting] [SEPARATOR 'sep']) Quick Example SELECT GROUP_CONCAT(city) FROM cities GROUP BY state; Separator Comma (,) by default, '' eliminates separator NULL Values Skipped Max Length 1024 by default, specified by group_concat_max_len system variable Version: MySQL 5.6 text/html 2011-12-22T15:08:30+00:00 https://www.sqlines.com/mysql/functions/replace?rev=1324566510&do=diff REPLACE function replaces a string with the specified value. The comparison is case-sensitive. Quick Example: -- Replace word 'York' with 'Haven' in string 'New York' ('New York' -> 'New Haven') SELECT REPLACE('New York', 'York', 'Haven'); text/html 2011-12-16T16:38:41+00:00 https://www.sqlines.com/mysql/functions/str_to_date?rev=1324053521&do=diff STR_TO_DATE function converts a string in the specified format to DATETIME, DATE or TIME value. Syntax STR_TO_DATE(string, format) Quick Example SELECT STR_TO_DATE('17-09-2010','%d-%m-%Y'); Error Returns NULL if the format is not matched, or datetime value is not valid Version: MySQL 5.6