summaryrefslogtreecommitdiff
path: root/modules/pref-filters.php
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2008-05-17 03:58:13 +0100
committerAndrew Dolgov <[email protected]>2008-05-17 03:58:13 +0100
commita3f4e4d3464c6de4d1610452c56ea9e8fb632aa7 (patch)
treeabc6fd3b1332f4e0d91b3465b829217915d605ad /modules/pref-filters.php
parent9c87d75cc0d72669a25f05d5888f055d799e9363 (diff)
filter prefs: make search case insensitive
Diffstat (limited to 'modules/pref-filters.php')
-rw-r--r--modules/pref-filters.php12
1 files changed, 6 insertions, 6 deletions
diff --git a/modules/pref-filters.php b/modules/pref-filters.php
index ac71c96a2..9d39258a4 100644
--- a/modules/pref-filters.php
+++ b/modules/pref-filters.php
@@ -232,8 +232,8 @@
<input id=\"filter_search\" size=\"20\" type=\"search\"
onchange=\"javascript:updateFilterList()\" value=\"$filter_search\">
<input type=\"submit\" class=\"button\"
- onclick=\"javascript:updateFilterList()\" value=\"".__('Search')."\">&nbsp<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
- <img src='images/sign_quest.gif'></a>
+ onclick=\"javascript:updateFilterList()\" value=\"".__('Search')."\"><p<a class='helpLinkPic' href=\"javascript:displayHelpInfobox(2)\">
+ <img src='images/sign_quest.gif'></a></p>
</div>";
@@ -253,10 +253,10 @@
if ($filter_search) {
$filter_search = db_escape_string($filter_search);
$filter_search_query = "(
- ttrss_filter_actions.description LIKE '%$filter_search%' OR
- reg_exp LIKE '%$filter_search%' OR
- ttrss_feeds.title LIKE '%$filter_search%' OR
- ttrss_filter_types.description LIKE '%$filter_search%') AND";
+ UPPER(ttrss_filter_actions.description) LIKE UPPER('%$filter_search%') OR
+ UPPER(reg_exp) LIKE UPPER('%$filter_search%') OR
+ UPPER(ttrss_feeds.title) LIKE UPPER('%$filter_search%') OR
+ UPPER(ttrss_filter_types.description) LIKE UPPER('%$filter_search%')) AND";
} else {
$filter_search_query = "";
}