my @names = split(/\s/, param("name")); my $name = join("%", @names) . " OR " . join("%", reverse @names); my $sql = "select * from table where name like $name";