select count(*) from file where file.path like "c:...
# general
s
select count(*) from file where file.path like "c:\local-folder\%" works