Return a number formatted to specified number of decimal places
23
24
LOAD_FILE()
25
-----------
26
27
Load the named file
28
29
LPAD()
30
-------
31
32
Return the string argument, left-padded with the specified string
33
34
MAKE_SET()
35
----------
36
37
Return a set of comma-separated strings that have the corresponding bit in bits set
38
39
MATCH()
40
-------
41
42
Perform full-text search
43
44
MID()
45
-----
46
47
Return a substring starting from the specified position
48
49
ORD()
50
-----
51
52
Return character code for leftmost character of the argument
53
54
QUOTE()
55
-------
56
57
Escape the argument for use in an SQL statement
58
59
REPEAT()
60
--------
61
62
Repeat a string the specified number of times
63
64
REPLACE()
25
.. _format-function:
26
27
FORMAT
28
------
29
30
Return a number formatted to specified number of decimal places.
31
32
.. _load-file-function:
33
34
LOAD_FILE
65
35
---------
66
36
37
Load the named file.
38
39
.. _lpad-function:
40
41
LPAD
42
----
43
44
Return the string argument, left-padded with the specified string.
45
46
.. _make-set-function:
47
48
MAKE_SET
49
--------
50
51
Return a set of comma-separated strings that have the corresponding bit in bits set.
52
53
.. _match-function:
54
55
MATCH
56
-----
57
58
Perform full-text search.
59
60
.. _mid-function:
61
62
MID
63
---
64
65
Return a substring starting from the specified position.
66
67
.. _quote-function:
68
69
QUOTE
70
-----
71
72
Escape the argument for use in an SQL statement.
73
74
.. _repeat-function:
75
76
REPEAT
77
------
78
79
Repeat a string the specified number of times.
80
81
.. _replace-function:
82
83
REPLACE
84
-------
85
67
86
The REPLACE() function returns a string with all occurrences of the 'from_str' replaced by 'to_str'. REPLACE is case-sensitive when searching for 'from_str'.
68
87
69
88
Syntax:
78
97
79
98
Returns: vvv.google.com
80
99
81
REVERSE()
82
---------
100
.. _reverse-function:
101
102
REVERSE
103
-------
83
104
84
105
This function returns a string argument with the characters in reverse order.
85
106
89
110
90
111
Returns: dcba
91
112
92
RIGHT()
93
-------
113
.. _right-function:
114
115
RIGHT
116
-----
94
117
95
118
Return the specified rightmost number of characters
96
119
97
RPAD()
98
------
120
.. _rpad-function:
121
122
RPAD
123
----
99
124
100
125
Append string the specified number of times
101
126
102
SOUNDEX()
103
---------
127
.. _soundex-function:
128
129
SOUNDEX
130
-------
104
131
105
132
Return a soundex string
106
133
107
108
SUBSTRING()
109
-----------
134
.. _substr-function:
135
136
SUBSTR
137
------
138
139
Synonym for SUBSTRING().
140
141
.. _substring-function:
142
143
SUBSTRING
144
---------
110
145
111
146
Returns the substring as specified
112
147
132
167
FROM Students
133
168
LIMIT 10;
134
169
135
170
.. _substring-index-function:
171
172
173
SUBSTRING_INDEX
174
---------------
175
176
Return a substring from a string before the specified number of occurrences of the delimiter.