MySQL字符串函数
时间：2019-11-20 08:52:24 来源:igfitidea点击:
本页显示最常用的MySQL字符串函数，这些函数可让您有效地处理字符串数据。
| 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 |
