my $query = "SELECT * FROM People where Name = '$console'";

Please learn to use placeholders as early as possible and get used to it. they make your database statements more secure and the code is in most cases cleaner to read. You don't need to care about quoting the value.
see also http://bobby-tables.com/

my $query = "SELECT * FROM People where Name = ?";
# later:
$query1->execute($console);
[download]