MySQL string functions

Status

Done

Text

Comprehensive collection of MySQL string manipulation functions including LENGTH(), UPPER(), LOWER(), TRIM(), and SUBSTRING().

CONCAT

Concatenate two or more strings into a single string.

CONCAT_WS

Return a single string by concatenating multiple strings separated by a specified separator.

INSTR

Return the position of the first occurrence of a substring in a string.

LENGTH

Get the length of a string in bytes.

CHAR_LENGTH

Return the length of a string measured in characters.

LEFT

Get a specified number of leftmost characters from a string.

LOWER

Return a string converted to lowercase.

LOCATE

Return the position of a substring within a given string starting at a specified position.

LTRIM

Remove all leading spaces from a string.

REPLACE

Replace all occurrences of a substring in a string with a new one.

REPEAT

Repeat a string a specified number of time.

REVERSE

Reverse a string.

RIGHT

Get a specified number of rightmost characters from a string.

RTRIM

Remove all trailing spaces from a string.

SUBSTRING

Extract a substring starting from a position with a specific length.

SUBSTRING_INDEX

Return a substring from a string before a specified number of occurrences of a delimiter.

TRIM

Remove unwanted characters from a string.

FIND_IN_SET

Find a string within a comma-separated list of strings.

FORMAT

Format a number with a specific locale, rounded to the number of decimals.

UPPER

Convert a string to uppercase.

MySQL INSERT() Function