node-mysql single value for multiple query parameters

Question

Currently, in node.js, if I want to search for a string in multiple columns in a MySQL table I have to do like this:

mysqlConnection.query(
    "SELECT * FROM my_table WHERE column_a LIKE ? OR column_b LIKE ? OR column_c LIKE ?",
    [searchString, searchString, searchString],
    callback
);

I want to be able to do it like this:

mysqlConnection.query(
    "SELECT * FROM my_table WHERE column_a LIKE ? OR column_b LIKE ? OR column_c LIKE ?", 
    searchString, callback
);

Or maybe even with named parameters:

mysqlConnection.query(
    "SELECT * FROM my_table WHERE column_a LIKE :searchString OR column_b LIKE :searchString OR column_c LIKE :searchString",
    {searchString: "needle"},
    callback
);

Is there a way I can do it?

@robertklep Well, that's pretty much what I'm looking for... but I don't think I should be trusted to prepare the statement myself. I might end up poking holes in the security. — starleaf1
– starleaf1, Commented Apr 8, 2017 at 14:15
Well, the code that I linked to is provided by the developer of mysql, and AFAICS it's exactly what you want :) — robertklep
– robertklep, Commented Apr 8, 2017 at 14:16

Rafo · Accepted Answer · 2022-06-18 15:41:51Z

3

you can enable named parameter when creating your db pool connection.

const connection = mysql.createPool({
  ...yourConfig,
  namedPlaceholders: true,
});

edit: As @robertklep explained it only works on mysql2 npm package

edited Jun 18, 2022 at 15:41

answered Jun 17, 2022 at 18:59

Rafo

6849 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

robertklep Over a year ago

To be clear: that will work with mysql2, not with mysql.

Collectives™ on Stack Overflow

node-mysql single value for multiple query parameters

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related