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.

The MySQL REPLACE() function replaces all case-sensitive occurrences of a substring within a string, with a new substring.

The MySQL REVERSE() function reverses a string and returns the result.

The MySQL RIGHT() function extracts a number of characters from a string, starting from right.

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

The MySQL RTRIM() function removes trailing spaces from a string.

The MySQL SPACE() function returns a string of the specified number of space characters.

The MySQL STRCMP() function compares the lengths two strings.

The MySQL SUBSTR() function extracts a substring from a string, starting from any position.

The MySQL SUBSTRING() function extracts a substring from a string, starting from any position.

The MySQL SUBSTRING_INDEX() function returns a substring of a string before a specified number of delimiter occurs.

The MySQL TRIM() function removes leading and trailing spaces from a string.

The MySQL UCASE() function converts a string to upper case.

The MySQL UPPER() function converts a string to upper case.