Skeleton documentation for all plugins, more complete docu for first half of plugins. Clean up plugin.ini titles and descriptions. Reformat and reorganize root index. Change Administrative to Administration and remove empty files (logging, etc.) Add, fix, and tag documentation for functions.
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
.. _ord-function:
68
69
ORD
70
---
71
72
Return character code for leftmost character of the argument.
73
74
.. _quote-function:
75
76
QUOTE
77
-----
78
79
Escape the argument for use in an SQL statement.
80
81
.. _repeat-function:
82
83
REPEAT
84
------
85
86
Repeat a string the specified number of times.
87
88
.. _replace-function:
89
90
REPLACE
91
-------
92
67
93
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
94
69
95
Syntax:
78
104
79
105
Returns: vvv.google.com
80
106
81
REVERSE()
82
---------
107
.. _reverse-function:
108
109
REVERSE
110
-------
83
111
84
112
This function returns a string argument with the characters in reverse order.
85
113
89
117
90
118
Returns: dcba
91
119
92
RIGHT()
93
-------
120
.. _right-function:
121
122
RIGHT
123
-----
94
124
95
125
Return the specified rightmost number of characters
96
126
97
RPAD()
98
------
127
.. _rpad-function:
128
129
RPAD
130
----
99
131
100
132
Append string the specified number of times
101
133
102
SOUNDEX()
103
---------
134
.. _soundex-function:
135
136
SOUNDEX
137
-------
104
138
105
139
Return a soundex string
106
140
107
108
SUBSTRING()
109
-----------
141
.. _substr-function:
142
143
SUBSTR
144
------
145
146
Synonym for SUBSTRING().
147
148
.. _substring-function:
149
150
SUBSTRING
151
---------
110
152
111
153
Returns the substring as specified
112
154
132
174
FROM Students
133
175
LIMIT 10;
134
176
135
177
.. _substring-index-function:
178
179
180
SUBSTRING_INDEX
181
---------------
182
183
Return a substring from a string before the specified number of occurrences of the delimiter.