Skip to content

Instance Method

where(_:_:column:)

Adds a column to column comparison to this builder’s WHERE clause by ANDing.
@discardableResult func `where`(_ lhs: SQLIdentifier, _ op: SQLBinaryOperator, column rhs: SQLIdentifier) -> Self

Discussion

builder.where("firstName", .equal, column: "lastName")

This method compares two columns.

SELECT * FROM "users" WHERE "firstName" = "lastName"