TableRunner.where() method
Home > @direct-sqlite/core > TableRunner > where
TableRunner.where() method
Section titled “TableRunner.where() method”Shorthand helper to quickly initialize a full row read operation matching a specific filter criteria.
Signature:
where<K extends keyof TRow>(column: K, operator: ComparisonOperator, value: TRow[K] | TRow[K][] | null): SelectQueryBuilder<TRow, keyof TRow>;Parameters
Section titled “Parameters”|
Parameter |
Type |
Description |
|---|---|---|
|
column |
K |
The column name to apply the WHERE condition on. Should be a key of the table’s row type. |
|
operator |
ComparisonOperator |
The comparison operator to use in the WHERE condition. Should be one of the defined ComparisonOperator types. |
|
value |
TRow[K] | TRow[K][] | null |
The value to compare against. Can be a single value, an array of values, or null. |
Returns:
SelectQueryBuilder<TRow, keyof TRow>
A SelectQueryBuilder instance for building and executing the SELECT query.