~drizzle-trunk/drizzle/development

The following SELECT statement includes a WHERE clause in order to search for job titles that start with "DIRECTOR", by using the percentage wildcard after the lookup value.

For example: ::

For example:

.. code-block:: mysql

SELECT title, field

FROM job_detail

REGEXP

------

Returns values that match a regular expression pattern; they are commonly used for creating complex searches. Here is an example of using a REGEXP (Regular Expression) match: ::

Returns values that match a regular expression pattern; they are commonly used for creating complex searches. Here is an example of using a REGEXP (Regular Expression) match:

.. code-block:: mysql

SELECT title, category_name

FROM film_detail

WHERE title REGEXP '^AIRP[LO]'

ORDER BY title;

Other REGEXP examples: :;

Other REGEXP examples:

.. code-block:: mysql

SELECT 'abcabc' REGEXP 'abc',

'abcabc' REGEXP 'cb';

The search pattern may describe only a part of string. To match entire string, use ^ and $ in the search: ::

The search pattern may describe only a part of string. To match entire string, use ^ and $ in the search:

.. code-block:: mysql

SELECT 'abc' REGEXP '^abc$', 'abcabc' REGEXP '^abc$';

SELECT 'cde' REGEXP '[a-c]+', 'efg' REGEXP '[a-c]+';

SELECT 'abcabc' REGEXP 'ABC', 'abcabc' REGEXP BINARY 'ABC';

Older »