> For the complete documentation index, see [llms.txt](https://dexiejs.typogram.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://dexiejs.typogram.co/whereclause.md).

# WhereClause

Represents a filter on an index or primary key.

#### Sample

```javascript
db.friends.where("shoeSize").between(40, 45).count(function(count) {
    console.log("I have " + count + " friends with the shoe size between 40 and 45");
});
```

#### Methods

[**above()**](/whereclause/whereclause.above.md)

Returns a collection of objects where index is above given key

[**aboveOrEqual()**](/whereclause/whereclause.aboveorequal.md)

Returns a collection of objects where index is above or equal given key

[**anyOf()**](/whereclause/whereclause.anyof.md)

Returns a collection of objects where index is equal to any of the keys in given array

[**anyOfIgnoreCase()**](/whereclause/whereclause.anyofignorecase.md)

Returns a collection of objects where index matches any of given strings, ignoring case differences.

[**below()**](/whereclause/whereclause.below.md)

Returns a collection of objects where index is below given key

[**belowOrEqual()**](/whereclause/whereclause.beloworequal.md)

Returns a collection of objects where index is below or equal given key

[**between()**](/whereclause/whereclause.between.md)

Returns a collection of objects where index is between given boundaries

[**equals()**](/whereclause/whereclause.equals.md)

Returns a collection of objects where index equals given key

[**equalsIgnoreCase()**](/whereclause/whereclause.equalsignorecase.md)

Returns a collection of objects where index equals given string-key ignoring case differences

[**inAnyRange()**](/whereclause/whereclause.inanyrange.md)

Returns a collection where index is within any of the given ranges.

[**noneOf()**](/whereclause/whereclause.noneof.md)

Returns a collection where index equals anything but any of the keys in given array

[**notEqual()**](/whereclause/whereclause.notequal.md)

Returns a collection where index equals anything but given value

[**startsWith()**](/whereclause/whereclause.startswith.md)

Returns a collection of objects where index starts with given string-key

[**startsWithAnyOf()**](/whereclause/whereclause.startswithanyof.md)

Returns a collection of objects where index starts with any of the given strings

[**startsWithIgnoreCase()**](/whereclause/whereclause.startswithignorecase.md)

Returns a collection of objects where index starts with given string-key ignoring case differences

[**startsWithAnyOfIgnoreCase()**](/whereclause/whereclause.startswithanyofignorecase.md)

Returns a collection of objects where index starts with any of given strings, ignoring case differences

#### See Also

[Table.where()](/table/table.where.md) - the method that returns a WhereClause instance.

[Collection](/collection.md) - where you can continue filtering your query