And

Definition

The and methods allows you to add the AND operator to a WHERE clause.

Available methods

1. and(KCondition kCondition)

• kCondition: which contains all the information about the condition that will be added to the WHERE clause with an AND operator.

2. and(KRaw kRaw)

• kRaw: is a raw content which will be added in the WHERE clause with an AND operator.

Method hierarchy

The and method can be used right after the following methods:

• where, and, andNot, or, orNot

and the subsequent methods that can be called are:

• and, andNot, or, orNot, returning, execute

Example: KCondition

Java code:

k
.deleteFrom(APP_USER)
.where(APP_USER.ID.gt(559))
.and(APP_USER.ACTIVE.isFalse())
.execute();

SQL generated:

DELETE
FROM app_user au
WHERE au.id > ?
AND au.active IS FALSE

Parameters:

• ?1: 559

Example: KRaw

Java code:

k
.deleteFrom(APP_USER)
.where(raw("au.id > 559"))
.and(raw("au.active IS FALSE"))
.execute();

SQL generated:

DELETE
FROM app_user au
WHERE au.id > 559
AND au.active IS FALSE

Parameters:

• None