I have a MySQL (MySQL v8) table where one column has a long string of information, but when I select it, I need to retrieve only a specific part of the long string.

phone_number 8181122274 8218241857 8178924294 8198884442 I want to query only phone number with criteria triple repeated digit and at least repeated double digit, I tried this regex function: WHERE phone_number REGEXP ‘(.)1{2}’ AND msisdn REGEXP ‘(.)1{1}’ but it seems invalid, if the query was correct it should only pull: 8181122274 8198884442 a correct where conditions […]