summaryrefslogtreecommitdiffstats
path: root/Bugzilla/Search.pm
diff options
context:
space:
mode:
Diffstat (limited to 'Bugzilla/Search.pm')
-rw-r--r--Bugzilla/Search.pm8
1 files changed, 4 insertions, 4 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index f0bc0b6fe..e69c3232f 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -988,10 +988,10 @@ sub init {
$term = "$ff != $q";
},
",casesubstring" => sub {
- $term = $dbh->sql_position($q, $ff);
+ $term = $dbh->sql_position($q, $ff) . " > 0";
},
",substring" => sub {
- $term = $dbh->sql_position(lc($q), "LOWER($ff)");
+ $term = $dbh->sql_position(lc($q), "LOWER($ff)") . " > 0";
},
",substr" => sub {
$funcsbykey{",substring"}->();
@@ -1466,7 +1466,7 @@ sub ListIDsForEmail {
} elsif ($type eq 'substring') {
&::SendSQL("SELECT userid FROM profiles WHERE " .
$dbh->sql_position(lc(::SqlQuote($email)), "LOWER(login_name)") .
- " " . $dbh->sql_limit(51));
+ " > 0 " . $dbh->sql_limit(51));
while (&::MoreSQLData()) {
my ($id) = &::FetchSQLData();
push(@list, $id);
@@ -1522,7 +1522,7 @@ sub GetByWordListSubstr {
foreach my $word (split(/[\s,]+/, $strs)) {
if ($word ne "") {
push(@list, $dbh->sql_position(lc(::SqlQuote($word)),
- "LOWER($field)"));
+ "LOWER($field)") . " > 0");
}
}