JS-查询MySQL WHERE col IN数组

Question

我的查询如下所示：SELECT MAX(x.id) as id,x.name, x.timestamp, x.balanceFROM sheet xJOIN    (SELECT p.name,MAX(id) AS max_id, p.rate    FROM sheet p GROUP BY p.name) yON y.max_id = x.idGROUP BY x.name查询仅IN（动态）名称的最佳做法是：array= ['flake', 'shane', 'klar']我用不同状态的join（）尝试了这样的事情：WHERE x.name IN (' + array.join() + ')