: REGEXP help Finding phone numbers (nnn) nnn- format
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?'
I've been trying to lick this for hours now
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
Hi,
Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn- ?
SELECT phone_work FROM leads WHERE phone_work REGEXP 'the_expression?'
I've been trying to lick this for hours now with
no avail.
Thank you,
Paul
--
MySQL
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work?
The query is:
SELECT 'boer bv' REGEXP '[ b|^b](?![v$|v ])';
So it has to match each starting 'b' and all the b's pf following words.
But now followed by a v(line
- Original Message -
From: Mike van Hoof [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Monday, January 08, 2007 1:36 PM
Subject: MYSQL REGEXP help
Hello,
i am try to make a regular expression work, but keep getting this error
message:
does anyone know how i can make it work
the Operators.
Try with.
SELECT 'boer bv' REGEXP '[b|^b](!?[v$|v])';
Thanks
ViSolve DB Team
- Original Message - From: Mike van Hoof [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Monday, January 08, 2007 1:36 PM
Subject: MYSQL REGEXP help
Hello,
i am try to make a regular
Hi,
Try with
mysql select 'oer bv' REGEXP '(^b|[[:blank:]])(!?v|$v)';
Thanks
ViSolve DB Team
- Original Message -
From: Mike van Hoof [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Monday, January 08, 2007 5:40 PM
Subject: Re: MYSQL REGEXP help
Hello,
this doesn't work
Sorry for the newbie question.
[Begin]$Groveling_non-programmer_string_of_excuses[End]. I imported a
bunch of records into a table. One of the fields came through bracketed
in double quotes, e.g., field data. I want remove the double quotes
but not the data bracketed within. E.g., field data to
:
Subject: RegExp Help
01/21/2004 10:55
PROTECTED]
ve.com cc:
Subject: RegExp Help
01/21/2004 10:55
AM
Please respond to
bcohen
Sorry for the newbie question
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
Ok,
I have a list/database of words that follows as ...
Top
...
Top/Arts/Food
Top/Arts/Food/Country
...
Top/World/America
Top/World/Japan
Top/World/Japan/Economy
Top/World/Japan/Food
Top/World/Japan/Food/Country
Top/World/Japan/Food/Country/By_Chef
...
How can I setup a regexp
-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
Top
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
17 matches
Mail list logo