diff options
Diffstat (limited to 'src')
-rw-r--r-- | src/Wallabag/CoreBundle/Repository/EntryRepository.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/Wallabag/CoreBundle/Repository/EntryRepository.php b/src/Wallabag/CoreBundle/Repository/EntryRepository.php index b9532fa2..4071301d 100644 --- a/src/Wallabag/CoreBundle/Repository/EntryRepository.php +++ b/src/Wallabag/CoreBundle/Repository/EntryRepository.php | |||
@@ -106,8 +106,9 @@ class EntryRepository extends EntityRepository | |||
106 | $qb->andWhere('e.isArchived = true'); | 106 | $qb->andWhere('e.isArchived = true'); |
107 | } | 107 | } |
108 | 108 | ||
109 | // We lower() all parts here because PostgreSQL 'LIKE' verb is case-sensitive | ||
109 | $qb | 110 | $qb |
110 | ->andWhere('e.content LIKE :term OR e.title LIKE :term')->setParameter('term', '%'.$term.'%') | 111 | ->andWhere('lower(e.content) LIKE lower(:term) OR lower(e.title) LIKE lower(:term) OR lower(e.url) LIKE lower(:term)')->setParameter('term', '%'.$term.'%') |
111 | ->leftJoin('e.tags', 't') | 112 | ->leftJoin('e.tags', 't') |
112 | ->groupBy('e.id'); | 113 | ->groupBy('e.id'); |
113 | 114 | ||