How to group the same phone numbers recorded in different formats?

Question

MySQL

Hi, tell me how to solve the problem
there is a table with phone numbers but they are written in different formats, they need to be grouped and counted
[phone]
70000000000
[phone]

can somehow be grouped by the last 7 characters for example?

Answer 1

SUBSTRING(phone, -3)
https://dev.mysql.com/doc/refman/8.0/en/string-fun...

Answer 2

Replace the brackets and the plus sign at the beginning with an empty value and get a single format. Group by result. mysql has all string functions for simple purposes.