节点JS MySQL查询IN子句和字符串数组

我试图通过城市IN子句的数组，但似乎在准备查询引号被删除

下面是代码

let city = ["Moscow", "Paris"];
let sql = 'SELECT* FROM cities WHERE city IN ('+city+')';
console.log(sql);

并在控制台中我得到这个

SELECT* FROM cities WHERE city IN (Moscow, Paris);

从而获得异常而执行的查询！

任何帮助吗？

试试这个，它会工作

var sql = "SELECT uid FROM cities where city IN ('" + gender.join("','") + "')";

结果： -

SELECT uid FROM cities where city IN ('Male','Female')

节点JS MySQL查询IN子句和字符串数组

我试图通过城市IN子句的数组，但似乎在准备查询引号被删除

下面是代码

let city = ["Moscow", "Paris"];
let sql = 'SELECT* FROM cities WHERE city IN ('+city+')';
console.log(sql);

并在控制台中我得到这个

SELECT* FROM cities WHERE city IN (Moscow, Paris);

从而获得异常而执行的查询！

任何帮助吗？

试试这个，它会工作

var sql = "SELECT uid FROM cities where city IN ('" + gender.join("','") + "')";

结果： -

SELECT uid FROM cities where city IN ('Male','Female')