title: Sql query with special characters - how to handle?
body: <p>I've few emp names like </p>
  
  <blockquote>
    <ol>
    <li>john,1  </li>
    <li>devil's  </li>
    <li>corn  </li>
    </ol>
  </blockquote>
  
  <p>something like this</p>
  
  <p>Now when i'm searching for these names I'm using </p>
  
  <pre><code>select * from emp where empname like ('john,1,devil's,corn')
  </code></pre>
  
  <p>But I'm not getting expected values also I'm getting error because emp name contains special charecters like , and '.</p>
  
  <p>Can someone help me out how to solve this?</p>