MySQL: a table with a list of regular expressions. Search for a phrase matching phrase

Question

Given:

A table that lists some regular expressions, for example:

id reg 1 %BC_ 2 __AC_ 3 %FC ... и т.д.

Required:

Find all the “id” whose regular expressions match the specific phrase.

For example, there is a code: “ DEACY ”, which corresponds to (in this example) only line No. 2.

Alexey Shimansky 37k 5 gold signs 48 silver marks 115 bronze marks · Accepted Answer · 2015-12-03T11:48:27

In your example, not regular expressions, but search masks. The query is quite simple if the other "regular expressions" are similar to this:

 SELECT * FROM regulars WHERE 'DEACY' LIKE reg;

1 answer 1