javascript - 在 NodeJS 上分配变量来查询 mysql

Question

嗨，我在nodejs上获取mysql数据时遇到一些问题

我的问题是“如何将 var n 添加到“%drawing eye%”中以获取数据库中的数据？”

  function showResult(req, res){
                var n = req.query.query
                mysql_conn.query('SELECT query_text FROM catalogsearch_query WHERE query_text LIKE "%drawing eye%" ORDER BY popularity DESC LIMIT 0 , 10', function(error, rows){
                res.render('result.html',{result:n , related: rows.map(row => row.query_text)})
                })
        }

Answer 1

做这样的事情LIKE "%' + n + '%"ORDER BY

function showResult(req, res) {
    var n = req.query.query
    mysql_conn.query('SELECT query_text FROM catalogsearch_query WHERE query_text LIKE "%' + n + '%" ORDER BY popularity DESC LIMIT 0 , 10', function(error, rows) {
        res.render('result.html', {
            result: n,
            related: rows.map(row => row.query_text)
        })
    })
}