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