title: Unexpected Mysqli WHERE is not null Value Returned
body: <p>Mysqli query to a table containing rows of data. </p>
  
  <p>When i use this <code>SELECT</code> it returns no rows when a row does exist with the desired request. </p>
  
  <p>I have written this several ways of which i have seen on various references but all return no rows. </p>
  
  <p>I wish to retrieve<code>(SELECT)</code> the latest<code>(DESC)(LIMIT 1)</code> row by<code>(datetime_upload)</code> in full<code>(*)</code> WHERE <code>(licensePath)</code> has something in the cell<code>(IS NOT NULL)</code>. </p>
  
  <p><strong>Q.</strong> I would like to know what i need to adjust in my select statement to return the desired result?</p>
  
  <p><img src="https://i.stack.imgur.com/lhK5g.png" alt="MySQL Table"></p>
  
  <p><strong>The Select:</strong></p>
  
  <pre><code>$query = "SELECT * FROM driver_docs WHERE driver_profileId LIKE '$uid' AND WHERE licensePath IS NOT NULL ORDER BY datetime_upload DESC LIMIT 1";
      $result = mysqli_query($conn, $query);
      $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
  
      if ($row) { 
          if ($row["licensePath"]) {
              echo "license";
          } 
      }
      else {
          echo "NO ROWS";
      }
  </code></pre>