How to make a select to select fields where there are more than 3 single characters?

Question

MySQL

It is required to select all rows from the table in which one of the fields contains more than three identical characters.

Answer 1

If we are talking about a specific character, for example, a point
www.sql.ru/forum/430173/kolichestvo-vhozhdeniy-pod...
If I understand correctly "Now you need to find more than 3 points in the field."

SELECT *
FROM table
WHERE  ( (LENGTH(field) - LENGTH(REPLACE(field, '.', ''))) / LENGTH('.') ) > 3

Answer 2

dev.mysql.com/doc/refman/5.7/en/regexp.html