title: mysql like query with special character '
body: <p>I wrote query for filter data using name and wrote following query</p>
  
  <pre><code>SELECT * FROM (`abc`) WHERE (name LIKE "%test\'!&amp;@#$\%-(3)\_er%")
  </code></pre>
  
  <p>It should return records which has name start with text "<strong>test</strong>"
  but it will not instead of if I modify query like </p>
  
  <pre><code>SELECT * FROM (`abc`) WHERE (name LIKE "%test%\'!&amp;@#$\%-(3)\_er%")
  </code></pre>
  
  <p>then it will give result. Why it is not give result with first query?
  Is there any other way to do this? </p>