On 5 Feb 2003, at 16:02, Darren Young wrote:
> I've looked through the mysql manual for information on regualar
> expressions, and all that it seems to have are references such as:
>
> SELECT "fo\nfo" REGEXP "^fo$";
>
> How can the REGEXP be applied to a 'SELECT field FROM table' kind of
> statement?
The same as LIKE or = or other similar operators. Normally you'd use
REGEXP in the WHERE clause of a query, something like
SELECT * FROM table_name WHERE column_name REGEXP '^[a-z]+$';
(to get all the rows where column_name consists of only letters).
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
