Where In
.where_in(column: str, value: list[Any])
column
: Name of the Column to filter
value
A list containing multiple values to search in
Shorthand for .where('id', 'in', values), the .where_in method add a "where in" clause to the query. Note that passing empty list as the value results in a query that never returns any rows.
db = Knex("<db name>")
db.select().from_("<table>").where_in("field", ["abc"])