more elegant way to store/find phone numbers

2007-09-25 Thread mysql
hi listers we have a mysql based application, wherein phone numbers may be stored and searched for. it is not the primary goal of this application to handle phone numbers. phone numbers usually are entered in a form like 099 999 99 99 or 099-999-99-99, or substings thereof. actually, the

RE: more elegant way to store/find phone numbers

2007-09-25 Thread Edward Kay
hi listers we have a mysql based application, wherein phone numbers may be stored and searched for. it is not the primary goal of this application to handle phone numbers. phone numbers usually are entered in a form like 099 999 99 99 or 099-999-99-99, or substings thereof. actually, the

Re: more elegant way to store/find phone numbers

2007-09-25 Thread Peter Brawley
does anyone have a nicer solution for this? How about comparing ereg_replace( [[:punct:]],, $colvalue ) with ereg_replace( [[:punct:]],, $comparisonvalue )? PB mysql wrote: hi listers we have a mysql based application, wherein phone numbers may be stored and searched for. it is not the