IL PROTECTED]>
To: Paul Nowosielski <[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+\
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 wa
cceptable 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
with 0?
I'd appreciate any kind of help very much!
Kind regards and greetings from Munich,
Felix
--
MySQL General Mailing List
For
oblem,
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
ents of the address ("123" 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
lastn
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
cont
;
> It is the same as using the LIKE operator wit more
> complex patterns
>
> Dobromir Velev
> [EMAIL PROTECTED]
> http://www.websitepulse.com
>
>
>
>
> - Original Message -
> From: "Darren Young" <[EMAIL PROTECTED]>
> To: <[E
PROTECTED]>
To: <[EMAIL PROTECTED]>
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" RE
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
> state
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
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 possibil
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 pos
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
nt to update 160 records in a table. The field contains a variable
>> value and a constant prefex like
>>
>> 'constant: unique value for this record'
>>
>> Is there such an UPDATE statement that would update this field into
>>
>> 'unique value
rwise is using Perls 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 = $
17 matches
Mail list logo
