var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "joshua",
  password: "Ccj^*1cX7812",
  database : "prices"
});

var name = 'The Smissmas Caribou'


con.connect(function(err) {
  if (err) throw err;
  var sql =  mysql.format("SELECT price FROM prices WHERE name = 'The Smissmas Caribou'");
  con.query(sql, function (err, result) {
  if (err) throw err;
  console.log(result);
    });
});