From: Paul Nowosielski
Date: December 3 2008 7:39am
Subject: REGEXP help Finding phone numbers (nnn) nnn-nnnn format
List-Archive: http://lists.mysql.com/mysql/215440
Message-Id: <177203.47957.qm@web30406.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

Hi,

Please, can anyone lend a hand in helping pullout
phone numbers from the DB that only match
the format (nnn) nnn-nnnn ?

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