JS-查询MySQL WHERE col IN数组

Question

我的查询如下所示：

SELECT MAX(x.id) as id,

x.name, x.timestamp, x.balance

FROM sheet x

JOIN

    (SELECT p.name,MAX(id) AS max_id, p.rate

    FROM sheet p GROUP BY p.name) y

ON y.max_id = x.id

GROUP BY x.name

查询仅IN（动态）名称的最佳做法是：

array= ['flake', 'shane', 'klar']

我用不同状态的join（）尝试了这样的事情：

WHERE x.name IN (' + array.join() + ')