i have table structure create table file(id text primary key, fname text, mimetype text, isdir boolean, location text); create index file_location on file (location); and following content in table: insert file (id, fname, mimetype, isdir, location) values('1', 'f1', 'pdf', false, 'c:/test/'); insert file (id, fname, mimetype, isdir, location) values('2', 'f2', 'pdf', false, 'c:/test/'); insert file (id, fname, mimetype, isdir, location) values('3', 'f3', 'pdf', false, 'c:/test/'); insert file (id, fname, mimetype, isdir, location) values('4', 'f4', 'pdf', false, 'c:/test/a/'); i want list out ids matching following criteria: select id file location '%/test/%'; i know not supported in cql, can please suggest approach should take these kind of wildcard search queries. please suggest. datastax enterprise adds full text search...