diff options
author | Andrew Dolgov <[email protected]> | 2008-05-17 03:58:13 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2008-05-17 03:58:13 +0100 |
commit | a3f4e4d3464c6de4d1610452c56ea9e8fb632aa7 (patch) | |
tree | abc6fd3b1332f4e0d91b3465b829217915d605ad | |
parent | 9c87d75cc0d72669a25f05d5888f055d799e9363 (diff) |
filter prefs: make search case insensitive
-rw-r--r-- | modules/pref-filters.php | 12 |
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')."\"> <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 = ""; } |