Mysql2 returns one value instead of multiple, why?

Question

MySQL

I am using mysql2 package for nodejs. I'm trying to make a query like this:

const requested = [47, 48, 49];

const images = await connection.query(
  'SELECT * FROM images WHERE id = ?',
  requested,
);

There are definitely records with these id's. In response, I get an array with one entry, the first (47). What am I doing wrong?

Answer 1

it is worth to esteem about syntax IN?
compare www.mysqltutorial.org/sql-in.aspx with your query.