MySQL Functions

This reference contains string, numeric, date, and some advanced functions in MySQL.

Returns the ASCII value for the specific character CHAR_LENGTH Returns the length of a string (in characters) CHARACTER_LENGTH Returns the length of a string (in characters)

CONCAT_WS Adds two or more expressions together with a separator

Returns the index position of a value in a list of values FIND_IN_SET Returns the position of a string within a list of strings

Formats a number to a format like "#,###,###.##", rounded to a specified number of decimal places

Inserts a string within a string at the specified position and for a certain number of characters

Returns the position of the first occurrence of a string in another string

Extracts a number of characters from a string (starting from left)

Returns the length of a string (in bytes)

Returns the position of the first occurrence of a substring in a string

Extracts a substring from a string (starting at any position)

Returns the position of the first occurrence of a substring in a string

Repeats a string as many times as specified