#Function

• SUBSTRING() : - SUBSTRING(string, start, length) (start is 1-based index, length is optional)

• LEFT() : - LEFT(string, length)

• RIGHT() : - RIGHT(string, length)

• CONCAT(): - CONCAT(string1, string2, ...)

  • Function in MySQL combines two or more strings into a single string. It’s often used for simple string concatenation (merging).

• GROUP_CONCAT() : - GROUP_CONCAT(expression, separator)

  • A MySQL aggregate function that concatenates values from multiple rows into a single string, with an optional separator. It's particularly useful for combining values in grouped queries.

• REPEAT() : - REPEAT(string, count)

• REGEXP : - REGEXP(expression, pattern)

• LOCATE() : - LOCATE(substring, string, start) (substring to find, the string to search within, optional, def is 1)

• SUBSTRING_INDEX() : - SUBSTRING_INDEX(string, delimiter, count)

  • Best use for csv files.

• UPPER()/LOWER() : - UPPER(string) LOWER(string)

• REPLACE() : - REPLACE(string, old_substring, new_substring)

  • Can be used for stripping all whitespaces from a string.

• LENGTH(): - LENGTH function to determine the length of a string in bytes, or the CHAR_LENGTH function to get the length in characters.