This page provides you with the most commonly used MariaDB string functions.
| Name | Description |
|---|---|
| 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 |
