title: How to insert text into mysql having quotes using perl
body: <p>How to insert text into mysql having quotes using perl ?
  It seems difficult to insert text containing ' &amp; ".
  I'm using Perl DBI module &amp; DB is mysql.</p>
  
  <p>UPDATE:</p>
  
  <p>here is my query </p>
  
  <pre><code>my $s = "INSERT INTO comment(guid,review_id) VALUES ('$guid','$review_id')";
  </code></pre>