title: MySql Search With Special Character
body: <p>I searching records from database using <code>MySql</code> as - </p>
  
  <pre><code>SELECT * FROM tab WHERE col LIKE '%myvalue%';
  </code></pre>
  
  <p>This is working fine and showing all the records having <code>myvalue</code>.</p>
  
  <p>Now the problem is i have some records like <code>my'value</code>, <code>myva'lue</code>, <code>myval-ue</code> and <code>my-value</code> And also want to include these records in search. Also when i search for <code>my'value</code> then it should show <code>myvalue</code> and <code>my-value</code>. </p>
  
  <p>How to achieve this? Any Help. Is it possible to do using <code>LIKE</code> operator?</p>