Interface: Where<TRecord, TResult>

knex.Knex.Where

Type parameters

Name	Default
TRecord	any
TResult	unknown

Hierarchy

• WhereRaw<TRecord, TResult>

• WhereWrapped<TRecord, TResult>

• WhereNull<TRecord, TResult>

  ↳ Where

Callable

▸ Where(raw: Raw<any>): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
raw	Raw<any>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1211

▸ Where(callback: QueryCallback<TRecord, TResult>): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
callback	QueryCallback<TRecord, TResult>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1212

▸ Where(object: Readonly<Partial<AnyOrUnknownToOther<MaybeRawRecord<ResolveTableType<TRecord, base>>, {}>>>): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
object	Readonly<Partial<AnyOrUnknownToOther<MaybeRawRecord<ResolveTableType<TRecord, base>>, {}>>>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1214

▸ Where(object: Readonly<Object>): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
object	Readonly<Object>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1216

▸ Where<T>(columnName: T, value: null | DbColumn<ResolveTableType<TRecord, base>[T]>): QueryBuilder<TRecord, TResult>

Type parameters:

Name	Type
T	string | number | symbol

Parameters:

Name	Type
columnName	T
value	null | DbColumn<ResolveTableType<TRecord, base>[T]>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1218

▸ Where(columnName: string, value: Value): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
columnName	string
value	Value

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1223

▸ Where<T>(columnName: T, operator: ComparisonOperator, value: null | DbColumn<ResolveTableType<TRecord, base>[T]>): QueryBuilder<TRecord, TResult>

Type parameters:

Name	Type
T	string | number | symbol

Parameters:

Name	Type
columnName	T
operator	ComparisonOperator
value	null | DbColumn<ResolveTableType<TRecord, base>[T]>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1225

▸ Where(columnName: string, operator: string, value: Value): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
columnName	string
operator	string
value	Value

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1231

▸ Where<T, TRecordInner, TResultInner>(columnName: T, operator: ComparisonOperator, value: QueryBuilder<TRecordInner, TResultInner>): QueryBuilder<TRecord, TResult>

Type parameters:

Name	Type
T	string | number | symbol
TRecordInner	-
TResultInner	-

Parameters:

Name	Type
columnName	T
operator	ComparisonOperator
value	QueryBuilder<TRecordInner, TResultInner>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1236

▸ Where<TRecordInner, TResultInner>(columnName: string, operator: string, value: QueryBuilder<TRecordInner, TResultInner>): QueryBuilder<TRecord, TResult>

Type parameters:

Name
TRecordInner
TResultInner

Parameters:

Name	Type
columnName	string
operator	string
value	QueryBuilder<TRecordInner, TResultInner>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1242

▸ Where(left: Raw<any>, operator: string, right: Value): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
left	Raw<any>
operator	string
right	Value

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1248

▸ Where<TRecordInner, TResultInner>(left: Raw<any>, operator: string, right: QueryBuilder<TRecordInner, TResultInner>): QueryBuilder<TRecord, TResult>

Type parameters:

Name
TRecordInner
TResultInner

Parameters:

Name	Type
left	Raw<any>
operator	string
right	QueryBuilder<TRecordInner, TResultInner>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1253

▸ Where(condition: boolean): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
condition	boolean

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1263

▸ Where<TResult2>(sql: string, bindings?: ValueDict | Value | QueryBuilder<any, any> | readonly (Value | QueryBuilder<any, any>)[]): QueryBuilder<TRecord, TResult2>

Type parameters:

Name	Default
TResult2	TResult

Parameters:

Name	Type
sql	string
bindings?	ValueDict | Value | QueryBuilder<any, any> | readonly (Value | QueryBuilder<any, any>)[]

Returns: QueryBuilder<TRecord, TResult2>

Defined in: node_modules/knex/types/index.d.ts:1489

▸ Where<TResult2>(raw: Raw<TResult2>): QueryBuilder<TRecord, TResult2>

Type parameters:

Name	Default
TResult2	TResult

Parameters:

Name	Type
raw	Raw<TResult2>

Returns: QueryBuilder<TRecord, TResult2>

Defined in: node_modules/knex/types/index.d.ts:1493

▸ Where(callback: QueryCallback<TRecord, TResult>): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
callback	QueryCallback<TRecord, TResult>

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1267

▸ Where(columnName: keyof TRecord): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
columnName	keyof TRecord

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1271

▸ Where(columnName: string): QueryBuilder<TRecord, TResult>

Parameters:

Name	Type
columnName	string

Returns: QueryBuilder<TRecord, TResult>

Defined in: node_modules/knex/types/index.d.ts:1272