diff options
| author | wn_ <[email protected]> | 2021-08-17 23:14:14 +0000 |
|---|---|---|
| committer | wn_ <[email protected]> | 2021-08-17 23:14:14 +0000 |
| commit | 23b4152c9e9379587aeddcf70d051596aa624d18 (patch) | |
| tree | c3e833b30e5c52302371baa52bc14d6536ac42fb /classes/pref/feeds.php | |
| parent | 992e9cd9e3bc1cbdbf6863dbaf090e43d78417ce (diff) | |
Make prefs feed search case-insensitive.
Previously the search query had to match lower title or feed_url (i.e. searching w/ uppercase wouldn't match).
Diffstat (limited to 'classes/pref/feeds.php')
| -rwxr-xr-x | classes/pref/feeds.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/classes/pref/feeds.php b/classes/pref/feeds.php index 2aaa3dc59..7c8ac4db1 100755 --- a/classes/pref/feeds.php +++ b/classes/pref/feeds.php @@ -82,7 +82,7 @@ class Pref_Feeds extends Handler_Protected { ->order_by_asc('title'); if ($search) { - $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE ?)', ["%$search%", "%$search%"]); + $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE LOWER(?))', ["%$search%", "%$search%"]); } foreach ($feeds_obj->find_many() as $feed) { @@ -253,7 +253,7 @@ class Pref_Feeds extends Handler_Protected { ->order_by_asc('title'); if ($search) { - $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE ?)', ["%$search%", "%$search%"]); + $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE LOWER(?))', ["%$search%", "%$search%"]); } foreach ($feeds_obj->find_many() as $feed) { @@ -289,7 +289,7 @@ class Pref_Feeds extends Handler_Protected { ->order_by_asc('title'); if ($search) { - $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE ?)', ["%$search%", "%$search%"]); + $feeds_obj->where_raw('(LOWER(title) LIKE ? OR LOWER(feed_url) LIKE LOWER(?))', ["%$search%", "%$search%"]); } foreach ($feeds_obj->find_many() as $feed) { |