1
String Functions and Operators
2
===============================
15
List of string operators and descriptions by type of function:
18
Comparative and regular functions
19
---------------------------------
21
=================== ====================================================================================================
23
=================== ====================================================================================================
24
LIKE Matches a simple pattern
25
NOT LIKE Negation of simple pattern matching
26
STRCMP() Compare two strings
27
NOT REGEXP Negation of REGEXP
28
REGEXP Returns values that match a regular expression pattern
29
RLIKE Synonym for REGEXP
30
=================== ====================================================================================================
33
Conversion and translation functions
34
------------------------------------
35
=================== ====================================================================================================
37
=================== ====================================================================================================
38
ASCII() Return numeric value of left-most character
39
BIN() Return a string representation of the argument
40
CHAR() Return the character for each integer passed
41
HEX() Return a hexadecimal representation of a decimal or string value
42
LOWER() Return the argument in lowercase
43
LCASE() Synonym for LOWER()
44
UCASE() Synonym for UPPER()
45
UNHEX() Convert each pair of hexadecimal digits to a character
46
UPPER() Convert to uppercase
47
=================== ====================================================================================================
50
Length and size functions
51
-------------------------
52
=================== ====================================================================================================
54
=================== ====================================================================================================
55
BIT_LENGTH() Return length of argument in bits
56
CHAR_LENGTH() Return number of characters in argument
57
LENGTH() Return the length of a string in bytes
58
OCTET_LENGTH() A synonym for LENGTH()
59
=================== ====================================================================================================
62
Formatting and modification functions
63
-------------------------------------
64
=================== ====================================================================================================
66
=================== ====================================================================================================
67
CONCAT() Returns a concatenated string
68
TRIM() Remove leading and trailing spaces
69
LTRIM() Remove leading spaces
70
RTRIM() Remove trailing spaces
71
=================== ====================================================================================================
77
=================== ====================================================================================================
79
=================== ====================================================================================================
80
FIELD() Return the index (position) of the first argument in the sequent arguments
81
FIND_IN_SET() Return the index position of the first argument within the second argument
82
INSTR() Return the index of the first occurrence of substring
83
LEFT() Return the leftmost number of characters as specified
84
INSERT() Insert a substring at the specified position up to the specified number of characters
85
LOCATE() Return the position of the first occurrence of substring
86
POSITION() A synonym for LOCATE()
87
=================== ====================================================================================================
90
Other string functions
91
----------------------
93
=================== ====================================================================================================
95
=================== ====================================================================================================
96
ELT() Return string at index number
97
EXPORT_SET() Return a string
98
FORMAT() Return a number formatted to specified number of decimal places
99
LOAD_FILE() Load the named file
100
LPAD() Return the string argument, left-padded with the specified string
101
MAKE_SET() Return a set of comma-separated strings that have the corresponding bit in bits set
102
MATCH Perform full-text search
103
MID() Return a substring starting from the specified position
104
ORD() Return character code for leftmost character of the argument
105
QUOTE() Escape the argument for use in an SQL statement
106
REPEAT() Repeat a string the specified number of times
107
REPLACE() Replace occurrences of a specified string
108
REVERSE() Reverse the characters in a string
109
RIGHT() Return the specified rightmost number of characters
110
RPAD() Append string the specified number of times
111
SOUNDEX() Return a soundex string
112
SUBSTR() Return the substring as specified
113
SUBSTRING_INDEX() Return a substring from a string before the specified number of occurrences of the delimiter
114
SUBSTRING() Return the substring as specified
115
=================== ====================================================================================================
added
removed
docs/functions/string.rst
