4
.. _coercibility-function:
9
Gets coercibility for an expression.
16
Return string at index number.
18
.. _export-set-function:
30
Return a number formatted to specified number of decimal places.
32
.. _load-file-function:
44
Return the string argument, left-padded with the specified string.
46
.. _make-set-function:
51
Return a set of comma-separated strings that have the corresponding bit in bits set.
58
Perform full-text search.
65
Return a substring starting from the specified position.
72
Escape the argument for use in an SQL statement.
79
Repeat a string the specified number of times.
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'.
90
REPLACE(str,from_str,to_str)
96
SELECT REPLACE('www.google.com', 'w', 'v');
98
Returns: vvv.google.com
100
.. _reverse-function:
105
This function returns a string argument with the characters in reverse order.
107
.. code-block:: mysql
109
SELECT REVERSE('abcd');
118
Return the specified rightmost number of characters
125
Append string the specified number of times
127
.. _soundex-function:
132
Return a soundex string
139
Synonym for SUBSTRING().
141
.. _substring-function:
146
Returns the substring as specified
148
Examples that use SUBSTRING() in the SELECT clause:
150
The SUBSTRING() function is used to extract a character string (using a given starting position and a given length).
152
.. code-block:: mysql
155
SUBSTRING(course_designater,6,3) as 'Course number'
157
WHERE course_designater LIKE 'Excel%'
160
You can also format a column using SUBSTRING() in combination with functions like LOWER() and UPPER().
162
.. code-block:: mysql
165
CONCAT(UPPER(SUBSTRING(lastname,1,1)),
166
LOWER(SUBSTRING(lastname,2,29)))
170
.. _substring-index-function:
176
Return a substring from a string before the specified number of occurrences of the delimiter.