I'm trying to create a regular expression query to match phone numbers
in a database field.
My issue is this , the numbers have no set standard for input in the db.
So the number in the db could be in multiple formats.
So I am wanting to find matches and ignore any non-numeric values and
need some help with the expression.
The query would be something like:
SELECT tel FROM leads WHERE do_not_call = '1' AND tel REGEXP 'the expression'
The number I am looking for will already have all the non numerics stripped and will
be in the format of nnnnnnnnnn.
Any help would be appreciated.