Dear All,
I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
EX:
333.333.
(333)333-
333-333-
33
So I am
[EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Monday, December 1, 2008 6:42:19 PM
Subject: RE: regular expressions matching only numeric characters in order
Hi
I am a bit of novice at Regexp, but I believe this will work for you
(\d+\d+\d+).*(\d+\d+\d+).*(\d+\d+\d+\d+)
Robert M
case.
So is there a way to use wildcards/regular expressions in IFNULL? Is
there another way to create a view that substitutes every NULL-value
with 0?
I'd appreciate any kind of help very much!
Kind regards and greetings from Munich,
Felix
--
MySQL General Mailing List
For list archives: http
,
that it doesn't reflect new columns in the original table in the view,
as there is no corresponding IFNULL-command in the view. This is not
acceptable in my case.
So is there a way to use wildcards/regular expressions in IFNULL? Is
there another way to create a view that substitutes every NULL-value
and
12345), they would match.
I am wondering, is there a way to search through a table like this (all
fields are varchar):
fname, lname, address, city, state, zip
Using regular expressions, to show any records which match another record on
lastname, street number, and zip? I could do this easily
Hello,
I¹m trying to filter a column of phone numbers that contains spaces,
parenthesis, dashes, and possibly letters using sql with the following
query. Am I going down the right path with the following sql statement or
should I be doing something totally different? I¹m trying to say use the
complex patterns
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com
- Original Message -
From: Darren Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 00:02
Subject: Regular Expressions
I've looked through the mysql manual
]
Sent: Thursday, February 06, 2003 00:02
Subject: Regular Expressions
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT fo\nfo REGEXP ^fo$;
How can the REGEXP be applied to a 'SELECT field FROM table
On 5 Feb 2003, at 16:02, Darren Young wrote:
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT fo\nfo REGEXP ^fo$;
How can the REGEXP be applied to a 'SELECT field FROM table' kind of
statement?
The
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT fo\nfo REGEXP ^fo$;
How can the REGEXP be applied to a 'SELECT field FROM table' kind of
statement?
Thanks,
Darren Young
mysql,query
Hi,
I am a web developer and I wrote a script that cycles through a bunch
of regular expressions stored in a database.
Is there or will there be a way to precompile and store precompiled
regular expressions in mysql? I would then need to run them against a
string/(var)char field
Hello all,
Is there a mysql function that extracts sub matches from regular
expressions. for example in perl when you match a string to a regular
expression like /\s+(\S+)\s+(\S+)/ the submatches (strings matching the
part of the expression between parenthesis) are available in variables
$1, $2
I've a question concerning negations of regular expressions - e.g. I
want the sentence this is nice to match, while the sentence this is
not nice should not match.
I only found possibilities for the negation of single characters on the
MySQL-site, but what about whole words?!
Greetings
Angela,
Monday, March 04, 2002, 1:25:44 PM, you wrote:
AH I've a question concerning negations of regular expressions - e.g. I
AH want the sentence this is nice to match, while the sentence this is
AH not nice should not match.
AH I only found possibilities for the negation of single
On Mon, Mar 04, 2002 at 12:25:44PM +0100, Angela Harneit wrote:
I've a question concerning negations of regular expressions - e.g. I
want the sentence this is nice to match, while the sentence this
is not nice should not match. I only found possibilities for the
negation of single
regular expressions like
(this is rather pseudocode just to make the point)
$foo = 'constant: unique value for this record';
$foo =~ s/constant:(.+)//sg;
$bar = $1; #(and hopefully $1 would hold 'unique value for this record')
UPDATE my_table
SET field = $bar
WHERE field = $foo;
Any ideas? Help
'constant: unique value for this record'
Is there such an UPDATE statement that would update this field into
'unique value for this record'
They way I would do it otherwise is using Perls regular expressions like
(this is rather pseudocode just to make the point)
$foo = 'constant
17 matches
Mail list logo