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