title: How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?
body: <p>My company runs MySQL in NO_BACKSLASH_ESCAPES mode. How can I escape a literal <code>%</code> or <code>_</code> in a LIKE query in this mode? The standard way is <code>\%</code>, but that doesn't work in this mode.</p>
  
  <p>Example: a column has the following values: <code>5% off</code>, <code>50% off</code>. The following query works in standard mode but not in NO_BACKSLASH_ESCAPES mode:</p>
  
  <pre><code>SELECT * FROM mytable
  WHERE mycol LIKE '5\% off'
  </code></pre>