I'm using mysqljs\mysql in a Node application and I've run into some trouble performing statements with 'in' clauses.
Under paramater escaping, the documentation states that:
Arrays are turned into list, e.g. ['a', 'b'] turns into 'a', 'b'
var sql = "SELET * FROM table WHERE name IN (?)";
var params = ['a', 'b', 'c'];
"SELET * FROM table WHERE name IN ('a')"