The variabe $uname = 'leander@whatever.com'

my $res = $dbh->selectall_arrayref('SELECT uname, pwd FROM login WHERE uname=' . $uname) || die $dbh->errstr;