From 23b4152c9e9379587aeddcf70d051596aa624d18 Mon Sep 17 00:00:00 2001 From: wn_ Date: Tue, 17 Aug 2021 23:14:14 +0000 Subject: 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). --- classes/pref/feeds.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'classes/pref/feeds.php') 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) { -- cgit v1.2.3