~drizzle-trunk/drizzle/development

Other String Functions

======================

.. _coercibility-function:

COERCIBILITY

------------

Gets coercibility for an expression.

.. _elt-function:

ELT

---

Return string at index number.

.. _export-set-function:

EXPORT_SET

----------

Return a string

.. _format-function:

FORMAT

------

Return a number formatted to specified number of decimal places.

.. _load-file-function:

LOAD_FILE

---------

Load the named file.

.. _lpad-function:

LPAD

----

Return the string argument, left-padded with the specified string.

.. _make-set-function:

MAKE_SET

--------

Return a set of comma-separated strings that have the corresponding bit in bits set.

.. _match-function:

MATCH

-----

Perform full-text search.

.. _mid-function:

MID

---

Return a substring starting from the specified position.

.. _quote-function:

QUOTE

-----

Escape the argument for use in an SQL statement.

.. _repeat-function:

REPEAT

------

Repeat a string the specified number of times.

.. _replace-function:

REPLACE

-------

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'.

Syntax:

REPLACE(str,from_str,to_str)

For example:

.. code-block:: mysql

	SELECT REPLACE('wwww.google.com', 'w', 'v');

Returns: vvv.google.com

.. _reverse-function:

REVERSE

-------

This function returns a string argument with the characters in reverse order.

.. code-block:: mysql

	SELECT REVERSE('abcd');

Returns: dcba

.. _right-function:

RIGHT

-----

Return the specified rightmost number of characters

.. _rpad-function:

RPAD

----

Append string the specified number of times

.. _soundex-function:

SOUNDEX

-------

Return a soundex string

.. _substr-function:

SUBSTR

------

Synonym for SUBSTRING().

.. _substring-function:

SUBSTRING

---------

Returns the substring as specified

Examples that use SUBSTRING() in the SELECT clause:

The SUBSTRING() function is used to extract a character string (using a given starting position and a given length).

.. code-block:: mysql

	SELECT  

        SUBSTRING(course_designater,6,3) as 'Course number'                   

	FROM Courses

	WHERE course_designater LIKE 'Excel%' 

	LIMIT 10;    

You can also format a column using SUBSTRING() in combination with functions like LOWER() and UPPER().

.. code-block:: mysql

	SELECT 

	CONCAT(UPPER(SUBSTRING(lastname,1,1)),

  	LOWER(SUBSTRING(lastname,2,29)))

	FROM Students

	LIMIT 10;

.. _substring-index-function:

SUBSTRING_INDEX

---------------

Return a substring from a string before the specified number of occurrences of the delimiter.