如何在nodejs mysql查询中使用传入的数组与指定的值进行比较？

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

const array = [1, 2, 3, 4, 5];
const value = 3;

const query = `SELECT * FROM your_table WHERE column_name IN (?)`;
connection.query(query, [array], (error, results) => {
  if (error) throw error;
  console.log(results);
});

connection.end();