The MySQL ASCII() function returns the ASCII value for the specific character.

The MySQL CHAR_LENGTH() function returns the length of a string in characters.

The MySQL CHARACTER_LENGTH() function returns the length of a string in characters.

The MySQL CONCAT() function adds two or more expressions together.

The MySQL CONCAT_WS() function adds two or more expressions together using a separator.

The MySQL FIELD() function returns the index position of a case-insensitive value in a list of values.

The MySQL FIND_IN_SET() function returns the position of a string within a list of strings.

The MySQL FORMAT() function formats a number to a format like “#,###,###.##”, rounded to a specified number of decimal places, and returns it as a string.

The MySQL INSERT() function inserts a string within a string at the specified position and for a certain number of characters.

The MySQL INSTR() function returns the position of the first occurrence of a case-insensitive string in another string.

The MySQL LCASE() function converts a string to lower-case.

The MySQL LEFT() function extracts a number of characters from a string, starting from left.

The MySQL LENGTH() function returns the length of a string in bytes.

The MySQL LOCATE() function returns the position of the first occurrence of a case-insensitive substring in a string.

The MySQL LOWER() function converts a string to lower case.

The MySQL LPAD() function left-pads a string with another string, to achieve a specified length.

The MySQL LTRIM() function removes leading spaces from a string.

The MySQL MID() function extracts a substring from a string, starting at any position from the beginning or end of the string.

The MySQL POSITION() function returns the position of the first occurrence of a case-insensitive substring in a string.

The MySQL REPEAT() function repeats a string as many times as specified.