server.js
app.get('/search',function(요청, 응답){
var id= parseInt(요청.body.id);
var title = 요청.query.value;
var sql2= 'SELECT * FROM login WHERE MATCH(title) AGAINST(title=? IN BOOLEAN MODE)';
var sql = 'SELECT * FROM login INNER JOIN post ON login.id=post.numberid WHERE post.title=?';
connection.query(sql2,[title],function(err,topcis){
if(err)
{
console.log(err);
응답.status(500).send('Internal Server Error');
}
else
{
응답.render('search.ejs',{posts : topcis});
}
})
})
에러
sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='wow' IN BOOLEAN MODE)' at line 1",
sql: "SELECT * FROM login WHERE MATCH(title) AGAINST(title='wow' IN BOOLEAN MODE)"
}