my $sth = $dbh->prepare('SELECT * FROM applicants WHERE last_name LIKE ? ORDER BY date_col, job_position'); $sth->execute("%$last_name%") or die $sth->errstr;