Using node.js, Express and node-mysql for restful access to MySQL. I have access working fine when I do a "select all" statement from MySQL DB. I have an issue with an SQL statement where one of the items is being generated by including req.params.id in my statement.
After the following:
var id = req.params.id;
I then produce the following SQL Statement:
"SELECT * FROM products WHERE Brand = " +id.
When the input - id - is, say LG, the console message tells me Unknown column "LG" in where clause. If I replace id with the string "LG" it returns fine. I have tried every combination of id but no success. Is anyone able to confirm bug with Node-mysql or do I have the statement wrong?