MariaDB String Functions

This page provides you with the most commonly used MariaDB string functions.

NameDescription
concat()Concatenate multiple strings into a single string
instr()Find the position of the first occurrence of a substring within a string
length()Return the length of a string in bytes and characters
left()Get a number of characters from the beginning of a string
lower()Return the lowercase form of a string
ltrim()Removes the leading space (or another character) from the beginning of a string
replace()Return a string with a substring is replaced by another substring
right()Get a number of characters from the end of a string
rtrim()Return a string with all trailing spaces (or other characters) removed
substring()Extract a substring from a string
substring_index()Return a substring from a string before a specified number of occurrences of a delimiter
trim()Remove both leading and trailing spaces (or other characters) from a string
find_in_set()Find a string within a comma-separated list of strings
format()Format a number by a specific locale
upper()Return the uppercase form of a string