From 2b27d986b374923a266c132ac0a67fb515d30d1c Mon Sep 17 00:00:00 2001 From: Frédéric Guillot Date: Fri, 26 Dec 2014 12:20:17 -0500 Subject: Use PicoDb operator ilike() instead of like() --- app/Model/TaskPaginator.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'app/Model') diff --git a/app/Model/TaskPaginator.php b/app/Model/TaskPaginator.php index 4ae3566c..bf537fbe 100644 --- a/app/Model/TaskPaginator.php +++ b/app/Model/TaskPaginator.php @@ -26,7 +26,7 @@ class TaskPaginator extends Base { return $this->taskFinder->getQuery() ->eq('project_id', $project_id) - ->like('title', '%'.$search.'%') + ->ilike('title', '%'.$search.'%') ->offset($offset) ->limit($limit) ->orderBy($column, $direction) @@ -45,7 +45,7 @@ class TaskPaginator extends Base { return $this->db->table(Task::TABLE) ->eq('project_id', $project_id) - ->like('title', '%'.$search.'%') + ->ilike('title', '%'.$search.'%') ->count(); } -- cgit v1.2.3