List:General Discussion« Previous MessageNext Message »
From:Paul Nowosielski Date:December 3 2008 7:39am
Subject:REGEXP help Finding phone numbers (nnn) nnn-nnnn format
View as plain text  
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



      
Thread
REGEXP help Finding phone numbers (nnn) nnn-nnnn formatPaul Nowosielski3 Dec
  • Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format SOLVEDPaul Nowosielski3 Dec
  • Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn formatwim.delvaux3 Dec