Using Regex

To return only documents that match regular expression, use the Regex method which enables RavenDB to perform server-side pattern matching queries.

The supplied regular expression must be .NET compatible.

Example

Sync
Async
RQL

// loads all products, which name
// starts with 'N' or 'A'
List<Product> products = session
  .Query<Product>()
  .Where(x => Regex.IsMatch(x.Name, "^[NA]"))
  .ToList();

// loads all products, which name
// starts with 'N' or 'A'
List<Product> products = await asyncSession
  .Query<Product>()
  .Where(x => Regex.IsMatch(x.Name, "^[NA]"))
  .ToListAsync();

from Products 
where regex(Name, '^[NA]')

Example​

Example