sample sql query callback on node.js

queryExample.js

//assuming you're using https://www.npmjs.com/package/mysql
const mysql = require('mysql');
const con = mysql.createConnection({
	host: "localhost",
	user: "yourusername",
	password: "yourpassword",
	database: "mydb"
});

socket.on('sqlQuery', function(queryData, callback){

	//we assume you pass a json with 
	//{"column": "*", "table": "users", "condition":"User=Bob"}

	//run the query
	con.query("SELECT" + queryData.column + " FROM " + queryData.table + " WHERE " + queryData.condition, function (err, result, fields) {
		if (err) throw err;
		console.log(result);

		//callback with result to ue4
		callback(result);
	});
});

👍