connection.query(query, function(err, res){
    console.log('Items for Sale');
    console.log('Id t Name t Department t Price t Quantityn');

        for (var i = 0; i < res.length; i++) {
            console.log(
                res[i].id + 't' + res[i].product_name + 't' + res[i].department + 't' +
                res[i].price + 't' + res[i].quantity + 'n');
        };
     runSearch();
});