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.
All the best,
Mike DeWolfe
---------------------------------------------------------------------
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
