MySQL String Functions
This page shows you the most commonly used MySQL string functions that allow you to manipulate character string data effectively.
| Name | Description |
|---|---|
| CONCAT | Concatenate two or more strings into a single string |
| INSTR | Return the position of the first occurrence of a substring in a string |
| LENGTH | Get the length of a string in bytes and in characters |
| LEFT | Get a specified number of leftmost characters from a string |
| LOWER | Convert a string to lowercase |
| LTRIM | Remove all leading spaces from a string |
| REPLACE | Search and replace a substring in 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 |