diff --git a/app/controllers/auto_completes_controller.rb b/app/controllers/auto_completes_controller.rb
index c6de2dd..b00deb3 100644
--- a/app/controllers/auto_completes_controller.rb
+++ b/app/controllers/auto_completes_controller.rb
@@ -35,7 +35,7 @@ class AutoCompletesController < ApplicationController
         @issues << scope.find_by_id($1.to_i)
       end
 
-      @issues += scope.where("LOWER(#{Issue.table_name}.subject) LIKE LOWER(?)", "%#{q}%").order(:id => :desc).limit(10).to_a
+      @issues += scope.like(q).order(:id => :desc).limit(10).to_a
       @issues.compact!
     end
     render :layout => false
diff --git a/app/models/issue.rb b/app/models/issue.rb
index b61c244..00e9899 100644
--- a/app/models/issue.rb
+++ b/app/models/issue.rb
@@ -98,6 +98,12 @@ class Issue < ActiveRecord::Base
     ids.compact!
     ids.any? ? where(:assigned_to_id => ids) : none
   }
+  scope :like, lambda {|q|
+    q = q.to_s
+    if q.present?
+      where("LOWER(#{table_name}.subject) LIKE LOWER(?)", "%#{q}%")
+    end
+  }
 
   before_validation :clear_disabled_fields
   before_create :default_assign