my $name = param('name');

# you may want to prevent search metacharacters:
   $name =~ s/(\%|_)/\\$1/g;

my $sth  = $dbh->prepare( "select * from clients where name like ?" );

$sth->execute($name) or die "Whoops!";
while ($sth->fetchrow_hashref) {
  ...
}

##</code><code>##

<form method=post>
  <input type=hidden name=action value="more_info">
  <input type=hidden name=name   value="whatever">
  <input type=submit value="More Info">
</form>