The use of express-mysql in

var a = "12714"

select * from table where id in"${a}"
Why does this sql return only one piece of data for advice

Mar.03,2021

try this var a = "(122.14)" or

var a=[12,14];
select * from table where id in '${a}'

FIND_IN_SET () this function solves

Menu