title: ignore dots and commas while making like query in mysql
body: <p>I have to do a fuzzy kind of match in a column in mysql I have a column which has fields like this</p>
  
  <pre><code>column_name
  -----------
  A.P Name1
  Name2, allias
  NAME1
  Name2
  </code></pre>
  
  <p>For case insensitivity I have done this </p>
  
  <pre><code>select coulmn_name from table where column_name like 'name' COLLATE UTF8_GENERAL_CI;
  </code></pre>
  
  <p>I would like to provide a search box where a user can type <code>ap</code> and my query would produce <code>A.P Name1</code> as the output from the table. How can I ignore <code>. &amp; ,</code> in mysql like statement</p>