title: regular expression or replace function in where clause of a mysql query
body: <p>I write a mysql query </p>
  
  <pre><code>select * from table where name like '%salil%'
  </code></pre>
  
  <p>which works fine but it will no return records with name 'sal-il', 'sa@lil'.</p>
  
  <p>So i want a query something like below</p>
  
  <p><code>select * from table where</code><strong>remove_special_character_from(name)</strong><code>like '%salil%'</code></p>
  
  <p><strong>remove_special_character_from(name)</strong> is a mysql method or a regular expression which remove all the special characters from name  before like executed. </p>