List:General Discussion« Previous MessageNext Message »
From:wim.delvaux Date:December 3 2008 2:46pm
Subject:Re: REGEXP help Finding phone numbers (nnn) nnn-nnnn format
View as plain text  
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-nnnn ?
"("[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


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