my $sth = $dbh->prepare("SELECT COUNT(keyword) AS count FROM c3_keyword_list WHERE keyword REGEXP ?"); $sth->execute('^foo');