here's another example from the manual... SELECT * FROM pet WHERE name REGEXP "^b";
see: 3.3.4.7 Pattern Matching --- Dobromir Velev <[EMAIL PROTECTED]> wrote: > Hi, > I use it in queries like > > SELECT * FROM table WHERE field REGEXP "patern"; > > It is the same as using the LIKE operator wit more > complex patterns > > Dobromir Velev > [EMAIL PROTECTED] > http://www.websitepulse.com > > > > > ----- Original Message ----- > From: "Darren Young" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, February 06, 2003 00:02 > Subject: Regular Expressions > > > > 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? > > > > Thanks, > > > > Darren Young > > > > mysql,query > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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