Node.js API with express & mysql - Search for multiple values in search parameter

Question

My current query looks like this:

router.get('/search?', function(req, res, next) {
    var title = req.query.title;
    var sql = "SELECT * from users WHERE title = ?"; 
    connection.query(sql, [title], function (error, results, fields) {
        res.json({"status": 200, "error": null, "response": results});
    });
});

It works if I enter:

localhost:4001/api/v1/users/search?title=mr

But how can I search for multiple values with OR ... like this:

localhost:4001/api/v1/users/search?title=mr,mrs,dr

Are you planning to search for partial matches or full matches? — anatoli
– anatoli, Commented Feb 21, 2018 at 11:15

Rishikesh Dhokare · Accepted Answer · 2018-02-21 11:16:35Z

2

Basically,

If you have multiple comma separated values in a query parameter, you can split them by , and use the sql IN clause.

If you have a single parameter value then your method already works fine.

router.get('/search?', function(req, res, next) {
    var title = req.query.title;
    var sql;
    if (title.includes(",")) {
        var params = title.split(",");
        sql = "SELECT * from users WHERE title IN " + params;      
    } else {
        sql = "SELECT * from users WHERE title = " + title;      
    }
    connection.query(sql, function (error, results, fields) {
        res.json({"status": 200, "error": null, "response": results});
    });
});

answered Feb 21, 2018 at 11:16

Rishikesh Dhokare

3,58727 silver badges35 bronze badges

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

3 Comments

Philipp M Over a year ago

... is there any way to also bind it .... or is it fairly save like shown?

Rishikesh Dhokare Over a year ago

i did not quite get what you are saying.

Philipp M Over a year ago

Well ... isnt't ... sql = "SELECT * from users WHERE title = " + title; ... a bit unsafe? ... and rather use placeholders '?' ? w3schools.com/nodejs/…

Collectives™ on Stack Overflow

Node.js API with express & mysql - Search for multiple values in search parameter

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related