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
2008 2:39:54 PM
Subject: 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 bee
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 Gen
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"
Sent: Monday, January 08, 2007 5:40 PM
Subject: Re: MYSQL REGEXP
7; is an Operator and ? is a wild character. Only wildcharacters
should be follow 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: "mys
?[v$|v])';
Thanks
ViSolve DB Team
- Original Message -
From: "Mike van Hoof" <[EMAIL PROTECTED]>
To: "mysql"
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
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
<[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
<[EMAIL PROTECTED]To:
<[EMAIL PROTECTED]>
ve.com> cc:
Subject: RegExp Help
01/21/2004 10:55
AM
Please respond to
ve.com> cc:
Subject: RegExp Help
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"
; "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 f
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 query/fi
17 matches
Mail list logo
