On Thu, Mar 15, 2001 at 08:50:01AM -0800, Mike DeWolfe wrote:
> I'm having a problem with REGEXP :
> 
> I have several rows that look like this :
> 
> Health : health services : safety : physical abuse : women
> Health : health services : safety : rescue
> Health : health services : safety : sexual abuse
> Health : health services : safety : sexual abuse : children
> Health : health services : safety : sexual abuse : women
> Health : health services : safety : travel-general cautions
> Health : volunteer services : children 
> 
> I want to do a search that selects "Health : {words]" but ignores
> "Health : {words] : {words]".  I've tried combinations of [\w]
> and[a-zA-Z] but they're all or nothing-- either I get all of the
> results with one or colons or none of the results.
> 
> Any help would be appreciated.

What about "Health : [^:]*$"

?

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878    Fax: (408) 530-5454
Cell: (408) 439-9951

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

Reply via email to