diff options
| author | Christian Weiske <cweiske@cweiske.de> | 2015-03-17 22:23:54 +0100 |
|---|---|---|
| committer | Christian Weiske <cweiske@cweiske.de> | 2015-03-17 22:23:54 +0100 |
| commit | 3e27ea29b9a3dd75480ac45b4e9b2b93c60f29fd (patch) | |
| tree | 0f16c20e0d3670d93defd86c279ebcc040cc2473 | |
| parent | 271a280e4ff443ccf333c437b0d4f2483d08c570 (diff) | |
| download | grauphel-3e27ea29b9a3dd75480ac45b4e9b2b93c60f29fd.tar.gz grauphel-3e27ea29b9a3dd75480ac45b4e9b2b93c60f29fd.zip | |
use ILIKE for case insensitive searches
see https://github.com/owncloud/core/pull/10958
| -rw-r--r-- | lib/notestorage.php | 4 |
1 files 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 ); |