Hi I have some problem on nodejs to get data on mysql
My question is 'How can I add var n into "%drawing eye%" to get data on database?'
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)})
})
}
Sachila Ranawaka :
do something like this LIKE \"%' + n + '%\" ORDER BY\n\nfunction showResult(req, res) {\n var n = req.query.query\n mysql_conn.query('SELECT query_text FROM catalogsearch_query WHERE query_text LIKE \"%' + n + '%\" ORDER BY popularity DESC LIMIT 0 , 10', function(error, rows) {\n res.render('result.html', {\n result: n,\n related: rows.map(row => row.query_text)\n })\n })\n}\n",
2017-05-01T13:27:12