Select Code to Download

$SQL = "SELECT FROM table WHERE  AND password='pwd'

my @WHERE = ();
push @WHERE, "username = '$username'" if $username;
...
push @WHERE, "name = '$name'" if $name;

$SQL = "SELECT FROM table WHERE " . join ' AND ', @WHERE;