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 REGEX

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

2008-12-03 Thread Paul Nowosielski
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 bee

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 Gen