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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]