# where

fun where(transaction: Transaction, table: Table, op: Op<Boolean>, isIgnore: Boolean = false, limit: Int? = null): Int

Creates a DeleteStatement that deletes only rows in table that match the provided op.

#### Return

Count of deleted rows.

fun where(transaction: Transaction, table: Table, op: Op<Boolean>, isIgnore: Boolean = false, limit: Int? = null, offset: Long? = null): Int

### Deprecated

This function that accepts an 'offset' argument will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-550/DeleteStatement-holds-unused-offset-property) with a use-case if your database supports the OFFSET clause in a DELETE statement.

#### Replace with

    where(transaction, table, op, isIgnore, limit)

Content copied to clipboard