title: How to match a regular expression from a SQL table to a text
body: <p>I have used before LIKE command to match patterns to a specific SQL table column. For example need all the rows which all have name started with &quot;A&quot;. But this case I am trying to solve things reversed , have a column &quot;Description&quot; where all the regular expressions row wise. And need to return specific rows which all match with a input text.</p>
  <pre><code>Table A
  Description
  ============
  \b[0-9A-Z ]*WT[A-Z0-9 ]*BALL\b
  \b[0-9A-Z ]*WG[A-Z0-9 ]*BAT\b
  \b[0-9A-Z ]*AX[A-Z0-9 ]*BAR\b
  </code></pre>
  <p>So Description column has these regular expressions and the input text &quot;BKP 200 WT STAR BALL&quot; So need to return the first row after select query since that the only match. If any one can help with the select query or idea, would be very helpful. If more details required please mention also.</p>