Is it possible to do a regular expression in a SQL query?

Question

MySQL

The field in the database has a value, for example 555787868111
Is it possible to make a SELECT of type 555*111 i.e. all values ​​in the database starting at 555 and ending at 111, regardless of what and how much is in the middle. If so, how to write such a request?

Answer 1

regular expressions are not needed for this, just LIKE
https://dev.mysql.com/doc/refman/5.5/en/string-com...

Answer 2

There is also REGEXP, if you need regular expressions =)
SELECT name FROM table WHERE name REGEXP "^555.*111$"