X-Git-Url: https://git.cweiske.de/grauphel.git/blobdiff_plain/891db33ead914486b6f4f7e32ebd3a7f511562e8..6d583b12847a04b3d49eb2b10c52028ba19f9e4f:/lib/notestorage.php 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 );