How can i bulk delete using knexjs(MySQL). I have entries in an array which matches a single field

Question

let i have database structure like this.

sr no.       name         age
 1.         hemant          25
 2.          amit           23
 3.         vikash          24

and i have array like following:

arr=['hemant','amit'];

Answer 1

You can use whereIn statement:

var arr = ['hemant', 'amit'];

knex('table')
  .whereIn('name', arr)
  .del();