node-mysql - return rows where column contains string

Question

I want to create a function that returns objects from DB where a string is contained in one of the object's columns.

This is my code:

router.get('/search-news', function (req, res) {

  var input = req.query.title; // user input
  var dynamicInput = '%'.concat(title.concat('%'));

  connection.query('SELECT * FROM news WHERE title = ?', [dynamicInput], function (err, rows) {
    console.log(err);
    res.json(rows);
  });
});

HTML:

<form action="search-news" class="form-inline right search-form" method="get">
   <input type="text" name="title" class="form-control" placeholder="Поиск..."></input>
   <input type="submit" class="btn btn-success" value="Поиск"></input>
</form>

However, this function always returns 0 records from the DB. Where is my problem?

Thank you

Gordon Linoff · Accepted Answer · 2015-03-28 13:52:42Z

2

Your dynamic input seems to be appending percent signs to the beginning and end of the string.

 var dynamicInput = '%'.concat(title.concat('%'));

It is highly unlikely that any strings actually have this format, so I suspect you want like:

 connection.query('SELECT * FROM news WHERE title like ?', [dynamicInput], function (err, rows) {

However, I am not familiar with nodejs, so there may be other problems as well.

answered Mar 28, 2015 at 13:52

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

Comments

Alexander Obidiegwu · Accepted Answer · 2022-06-10 13:26:53Z

0

This is the best and easiest way to do it.

 router.get('/search-news', function (req, res) {
    
      connection.query('SELECT * FROM news WHERE title = ?', [`%${req.query.title}%`], function (err, rows) {
        console.log(err);
        res.json(rows);
      });
    })

answered Jun 10, 2022 at 13:26

Alexander Obidiegwu

6621 gold badge7 silver badges20 bronze badges

Collectives™ on Stack Overflow

node-mysql - return rows where column contains string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related