From 3e27ea29b9a3dd75480ac45b4e9b2b93c60f29fd Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Tue, 17 Mar 2015 22:23:54 +0100
Subject: [PATCH] use ILIKE for case insensitive searches

see https://github.com/owncloud/core/pull/10958
---
 lib/notestorage.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib/notestorage.php b/lib/notestorage.php
index d1fe7e3..93311e4 100644
--- a/lib/notestorage.php
+++ b/lib/notestorage.php
@@ -287,8 +287,8 @@ class NoteStorage
             $keywordGroups['NOT'] = array();
         }
 
-        $sqlTplAnd = ' AND (note_title LIKE ? OR note_tags LIKE ? OR note_content LIKE ?)';
-        $sqlTplNot = ' AND NOT (note_title LIKE ? OR note_tags LIKE ? OR note_content LIKE ?)';
+        $sqlTplAnd = ' AND (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)';
+        $sqlTplNot = ' AND NOT (note_title ILIKE ? OR note_tags ILIKE ? OR note_content ILIKE ?)';
         $arData = array(
             $this->username
         );
-- 
2.30.2