title: SQL Count returns 0
body: <p>I have been trying to count the number of paths present in my table.</p>
  
  <p><a href="https://i.stack.imgur.com/wSGTK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wSGTK.png" alt="enter image description here"></a></p>
  
  <p>I am trying the following query</p>
  
  <pre><code>$db_con-&gt;query("SELECT COUNT(path) FROM mytable WHERE username='Rbiaali' AND path='C:\MAMP\htdocs\files\Rbiaali\9-5-2019 01 55 AM.zip'")-&gt;fetchColumn();
  </code></pre>
  
  <p>Also even if i use the below it is returning the same value: <code>0</code></p>
  
  <pre><code>path LIKE 'C:\MAMP\htdocs\files\Rbiaali\9-5-2019 01 55 AM.zip%'
  </code></pre>
  
  <p>As in the table, we can see that there are 6 entries with the path.</p>