title: MySQL: Select * where filename LIKE 'C:\Boston Office\User\SQL\RevitFile.rvt'
body: <p>I have a file path like the one above, and I actually copied and pasted from my MySQL table. I know that the path is correct, but I can't get any results.</p>
  
  <p>I have also tried</p>
  
  <ol>
  <li><code>'C:\\Boston Office\\User\\SQL\\RevitFile.rvt'</code> </li>
  <li><code>'%C:\Boston Office\User\SQL\RevitFile.rvt%'</code> </li>
  <li><code>'C:\Boston Office\User\SQL\RevitFile.rvt%'</code></li>
  </ol>
  
  <p>and all the above with double quotes. Why isn't this working?</p>