MySQL: a table with a list of regular expressions. Examination of the phrase



  • Dano:

    Table showing some regular expressions, for example:

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

    It requires:

    Find all "id " , which are regularly phrased under a specific phrase.

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



  • Your example is not regular expressions, but search masks. The request is simple enough if the other regular expressions are like this:

    SELECT * 
    FROM regulars
    WHERE 'DEACY' LIKE reg;
    



Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2