MySQL字符串函数

时间:2019-11-20 08:52:24  来源:igfitidea点击:

本页显示最常用的MySQL字符串函数,这些函数可让您有效地处理字符串数据。

NameDescription
CONCATConcatenate two or more strings into a single string
INSTRReturn the position of the first occurrence of a substring in a string
LENGTHGet the length of a string in bytes and in characters
LEFTGet a specified number of leftmost characters from a string
LOWERConvert a string to lowercase
LTRIMRemove all leading spaces from a string
REPLACESearch and replace a substring in a string
RIGHTGet a specified number of rightmost characters from a string
RTRIMRemove all trailing spaces from a string
SUBSTRINGExtract a substring starting from a position with a specific length.
SUBSTRING_INDEXReturn a substring from a string before a specified number of occurrences of a delimiter
TRIMRemove unwanted characters from a string.
FIND_IN_SETFind a string within a comma-separated list of strings
FORMATFormat a number with a specific locale, rounded to the number of decimals
UPPERConvert a string to uppercase