SELECT fullpath FROM files
WHERE name match '^[a-fA-F0-9]+$' and length(name)=50
and parentpath like '%\csvfiles\';

Find contents of a specific directory

... WHERE parentpath = 'C:\somepath\somedirectory\'

Find contents of a directory and all its subdirectories

... WHERE parentpath like 'C:\somepath\%'

Find directories by their contents

By individual properties of files contained

SELECT parentpath FROM files
WHERE extension in ('.py', '.c');

By collective properties of files contained

SELECT parentpath, count(*) FROM files
WHERE extension = '.xlsx'
GROUP BY parentpath
HAVING count(*) > 10;

End each query with a semicolon ;

It's often easier to write queries in a text editor, then copy and paste them to the Crab command line. You can paste multi-line queries in one go.

Queries run faster if you avoid wildcards on the left side of search patterns.

Cancel a query with Ctrl + C If this drops you to the Windows command line press up-arrow to recall the command which launched Crab, and start Crab without a scan path to continue querying the same data.