my $onlyonce = 1;
    foreach my $tempword ( @words )
    {
        if ( $onlyonce == 1 )
        {
            $searchstring .= "MajorDescription LIKE '%$tempword%' OR MajorName LIKE '%$tempword%'";
            $onlyonce = 0;
        }
        else
        {
            $searchstring .= " OR MajorDescription LIKE '%$tempword%' OR MajorName LIKE '%$tempword%
+'";
        }
    }

##</code><code>##

    $searchstring=join " OR ",
                  map "MajorDescription LIKE '\%$_\%' OR MajorName LIKE '\%$_\%'",
                  @words;

##</code><code>##

    my $or="";
    foreach my $tempword ( @words )
    {
        $searchstring .= " $or MajorDescription LIKE '%$tempword%' OR MajorName LIKE '%$tempword%'";
        # only set this once
        $or="OR" unless $or;
    }