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 REGEX
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
Subjec
<[EMAIL PROTECTED]>, <[EMAIL
PROTECTED]>
ve.com> cc:
Subject: RE: RegExp Help
> >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 TIT
>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:
<[
you should be able to use STR_REPLACE.
update 02093_xdir_links SET title = REPLACE("*","",title);
hth
jeff
"Bob Cohen"
; "Beginners
(E-mail)" <[EMAIL PROTECTED]>
Cc: "*MySQL 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
>
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
> Su
> -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/A