How to search by phone number?

Question

MySQL

The phone number in the database is stored in the format: [phone]
How can we implement a search for this number if we have such a [phone], or such a number: [phone] ? Preferably using regular expressions in SQL query

Answer 1

Regular expressions give a large overhead (excessive cost) with each search.
Why do you need this?
When saving to the database, bring the phone number to a single format (regular expressions are also possible), and then look for it without any problems.

Answer 2

I will support Vladimir, when entering into the database, always bring the number to one format, when searching, first with regular expressions, bring it to the desired format, and only then a simple sql search query.