EQ

Creates an equality comparison expression (= or IS).

This infix function compares the column to a specified value. It intelligently uses IS for null comparisons and = for all other values, which is the standard SQL behavior for checking equality with NULL.

Example

// Generates: "age" = 25
Employees.age EQ 25

// Generates: "manager_id" IS NULL
Employees.managerId EQ null

Parameters

See also

Creates an equality comparison expression (=) between two columns.

This infix function compares the current column with another column, generating a SQL condition like "column_a" = "column_b". This is useful for joining tables or comparing related fields within the same table.

Example

// Generates: "employees"."manager_id" = "managers"."id"
Employees.managerId EQ Managers.id

Parameters

Creates an equality comparison expression (=) between a column and a subquery.

This infix function checks if the value of the column is equal to the single result returned by the provided SelectStatement. The subquery should return a single column and at most one row.

Example

Tracks
     .select()
     .where {
         it.bytes EQ Tracks.select(MAX(Tracks.bytes))
     }
     .execute(con)

Parameters