title: How to perform a MySQL search that ignores punctuation in table data
body: <p>I have a multiple tables that contain large amounts of text.
  The text has a lot of punctuation in it.</p>
  <pre><code>MY_TABLE
  |ID|       TEXT        |
  ------------------------
  |1 |Dr. John Smith, FNP|
  </code></pre>
  <p>If I search:</p>
  <pre><code>SELECT * FROM `MY_TABLE` WHERE `TEXT` LIKE '%Dr. John Smith, FNP%'
  </code></pre>
  <p>Row 1 is returned.</p>
  <p>If I search:</p>
  <pre><code>SELECT * FROM `MY_TABLE` WHERE `TEXT` LIKE '%Dr John Smith FNP%'
  </code></pre>
  <p>0 Rows are returned.</p>
  <p>How can I perform a search that ignores the punctuation that is <strong>in the data</strong>?</p>
  <p>I have to search many tables at once, and each table contains 10's of thousands of rows, all with paragraphs of text.</p>
  <p>So - speed will be an issue.</p>