How to get value from function callback?

Question

JavaScript

How to get a value outside of a function?
The output inside the function shows the desired result, but outside is already undefined.

connection.connect();
connection.query('SELECT house_name FROM appartament WHERE street = ? AND house_number = ? AND house_name != ?',
            ['Степана Разина', 2, ''],
            function (error, results, fields) {
                if (error) throw error;
                result.house_name = results[0].house_name;
                console.log(result.house_name); //Выводит нужный результат
        });
connection.end();
    
console.log(result.house_name); //undefined

Answer 1

For example, a callback function:

connection.connect();
connection.query('SELECT house_name FROM appartament WHERE street = ? AND house_number = ? AND house_name != ?',
            ['Степана Разина', 2, ''],
            function (error, results, fields) {
                if (error) throw error;
                result = results[0].house_name;
                callback(result);
        });
connection.end();

function callback(data) {
  console.log(data);
  // делаем дела с data
}