title: MYSQL WHERE LIKE Statement
body: <p>I am attempting to use the LIKE clause in a mysql statement as follows:</p>
  
  <pre><code>SELECT * FROM batches WHERE FilePath LIKE '%Parker_Apple_Ben_20-10-1956%'
  </code></pre>
  
  <p>The data matched data within the 'FilePath' Column is:</p>
  
  <pre><code>C:\SCAN\Parker_Apple_Ben_20-10-1830\TEST
  </code></pre>
  
  <p>The above SQL statement works fine and picks up the relevent row, but if I for example add the "\" character into the end of the LIKE clause (like follows) it does not pick up the row correctly:</p>
  
  <pre><code>SELECT * FROM batches WHERE FilePath LIKE '%Parker_Apple_Ben_20-10-1956\%'
  </code></pre>
  
  <p>Funnily enough though if I place a '\' character at the beginning of LIKE clause (like follows) it picks up the row perfectly fine - this has me baffled. </p>
  
  <pre><code>SELECT * FROM batches WHERE FilePath LIKE '%\Parker_Apple_Ben_20-10-1956%'
  </code></pre>