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