By putting single quotes around it, it isn't a placeholder anymore...

my $sth = $dbh->prepare("SELECT COUNT(keyword) AS count FROM c3_keywor
+d_list WHERE keyword REGEXP ?");
$sth->execute('^foo');
[download]