mysql - Perl sql 全选

Question

这是我的代码

my $results = $dbh->selectall_hashref('SELECT * FROM sample.teachers where term like "$searchterm%"', 'teacher');
my $searchedresults= "";
foreach my $e (keys %$results) {
    print "$e\n";
    print "searching\n";
    $searchedresults = $e;
    }
    print $searchresult."\n";

我正在尝试从 mysql 服务器中的表中进行搜索。但似乎不起作用我使用硬编码方式对其进行了测试，将 $searchterm 替换为普通字符串，并且有效。但是我需要使用 $searchterm 但我不明白为什么它不能工作

Answer 1

my $results = $dbh->selectall_hashref(
   'SELECT * FROM sample.teachers where term like '.$dbh->quote("$searchterm%"),
   'teacher'
);

或

my $results = $dbh->selectall_hashref(
   'SELECT * FROM sample.teachers where term like ?,
   'teacher',
   undef,
   "$searchterm%"
);