Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format SOLVED

2008-12-03 Thread Paul Nowosielski 
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
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 been trying to lick this for hours now with
no avail.

Thank you,

Paul



  

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


  

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format

2008-12-03 Thread wim . delvaux 
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 'the_expression?'

 I've been trying to lick this for hours now with
 no avail.

 Thank you,

 Paul



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

REGEXP help Finding phone numbers (nnn) nnn-nnnn format

2008-12-02 Thread Paul Nowosielski 
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 General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]