MySQL - in the database in the lines of the regular expression. How to search by comparing data with a regular expression in strings?

Question

MySQL

Hello. I have regular expressions in my database. Help write a request. Something like this one:

SELECT * FROM column WHERE url_regexp ПОДХОДИТ ДЛЯ СТРОКИ "/about"

A line should be found that has a url_regexp like this, for example: ^(\/about).*.

Answer 1

SELECT * FROM `column` WHERE '/about' REGEXP url_regexp

Answer 2

1) in the line you leave only az : "about"
2) like %about%

Answer 3

There are probably not millions of routes, select everything (filtering everything that is possible during the selection) and sort it out on the client.
or use regexp from mysql