title: Can't escape semicolons in a MySQL UPDATE statement
body: <p>I am currently having an issue with a <strong>MySQL UPDATE</strong> statement I am working with. For some reason I am unable to escape the semicolons in the statement.</p>
  
  <p>If I remove all the semi-colons from the statement it works fine, so I know it has something to do with escaping the semi-colons.</p>
  
  <p>I've tried the standard method of escaping them by preceding them with a <code>\</code>, however that does nothing.</p>
  
  <p>I've also tried switching/swapping out all the single quotes for double quotes, and double quotes for single quotes, to reverse the ordering of them, which also does nothing.</p>
  
  <p>Here is the statement I am trying to execute:</p>
  
  <pre><code>UPDATE email_campaign_template 
                  SET content='&lt;style&gt;
  /* General */
  body {
      font-family: "Open Sans", sans-serif;
      color: #fdfcfc;
  }
  .container {
      max-width: 660px;
  }
  * {
    -webkit-box-sizing: border-box;
    -moz-box-sizing: border-box;
    box-sizing: border-box;
  }
  &lt;/style&gt;
  '
                  WHERE label='Property Flyer 01' 
                  AND email_campaign_id = '10';
  </code></pre>
  
  <p>This generates the following error, which is referring to the first semicolon in the statement:</p>
  
  <blockquote>
    <p>[Err] 1064 - You have an error in your SQL syntax; check the manual
    that corresponds to your MySQL server version for the right syntax to
    use near ''&lt;style> /* General */ body {    font-family: "Open Sans",
    sans-serif' at line 2</p>
  </blockquote>
  
  <p><strong>How can I successfully escape the semi-colons in order to be able to execute this RAW MySQL statement?</strong></p>