如何使用Node.js和MySQL实现过滤？

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接到数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to MySQL database');
});

// 执行查询语句
connection.query('SELECT * FROM mytable WHERE column = ?', ['value'], (err, results) => {
  if (err) throw err;
  console.log(results);
});

// 关闭数据库连接
connection.end();