my $sth = $dbh->prepare("
    SELECT blah FROM blah WHERE blah LIKE ?
");
$sth->execute('%foo%');