if (defined $status) { $statement = qq(SELECT COUNT(*) FROM name WHERE status = $status); }else{ $statement = qq(SELECT COUNT(*) FROM name WHERE age = "4"); } #### $sth = $dbh->prepare($statement); $sth-> execute();