Cannot delete rows using WHERE IN

[YannickFuereder]

Cannot delete rows using WHERE IN

[wellwelwel]

Hi @YannickFuereder, 🙋🏻‍♂️

When using execute, you will need to be explicit in your params:

await con.promise().execute("DELETE FROM exampleTable WHERE id IN (?)", [1]);

An example using more params:

await con.promise().execute("DELETE FROM exampleTable WHERE id IN (?, ?, ?)", [1, 5, 9]);

---

Related:

• #2168

[wellwelwel]

These comments can help to understand it better:

• #2168 (comment)
• #2168 (comment)

---

I'm closing this issue, but feel free to ask anything 🙋🏻‍♂️

[wellwelwel]

@sidorares, I believe documenting the differences between query and execute could be a good FAQ.

[sidorares]

Yes definitely, this makes a big portion of questions, especially the IN (?) scenario