This seems to do it:
SELECT phone_work FROM leads WHERE phone_work REGEXP '[(]{1}([0-9]){3}[)]{1}[
]?([^0-1]){1}([0-9]){2}[ ]?[-]?[ ]?([0-9]){4}'
- Original Message
From: Paul Nowosielski [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, December 3, 2008 2:39:54 PM
On Wednesday 03 December 2008 08:39:54 Paul Nowosielski wrote:
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
([0-9]{3}) [0-9]{3}-[0-9]{4}
I think
HTH
W
SELECT phone_work FROM leads WHERE phone_work REGEXP
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
hth
jeff
Bob Cohen
[EMAIL PROTECTED]To:
[EMAIL
you should be able to use STR_REPLACE.
DOH. Sorry, there is NO STR_REPLACE its just REPLACE.
jd
update 02093_xdir_links SET title = REPLACE(*,,title);
Thank you very much for responding. Sorry to be dense but will this SQL
find only those records with data in the TITLE field
cc:
Subject: RE: RegExp Help
01/21/2004 01:47
-Original Message-
From: Jon Shoberg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 4:47 PM
To: Beginners (E-mail)
Cc: *MySQL mail list; Jon Shoberg
Subject: Regexp Help !!!
Ok,
I have a list/database of words that follows as ...
Top
...
Top/Arts/Food
To: Jon Shoberg; Beginners (E-mail)
Cc: *MySQL mail list
Subject: RE: Regexp Help !!!
-Original Message-
From: Jon Shoberg [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 13, 2002 4:47 PM
To: Beginners (E-mail)
Cc: *MySQL mail list; Jon Shoberg
Subject: Regexp Help !!!
Ok
mail list [EMAIL PROTECTED]
Sent: Sunday, January 13, 2002 11:36 AM
Subject: RE: Regexp Help !!!
Thanks !
Glad I asked for some other thoughts on this. I totally over looked this
and given how my indexes are setup, this will work much better.
Thanks again,
Jon
-Original Message