diff options
Diffstat (limited to 'app/models/tag.rb')
-rw-r--r-- | app/models/tag.rb | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/app/models/tag.rb b/app/models/tag.rb index e2ad8e4db..15625ca43 100644 --- a/app/models/tag.rb +++ b/app/models/tag.rb @@ -13,8 +13,9 @@ class Tag < ApplicationRecord class << self def search_for(terms, limit = 5) + terms = Arel.sql(connection.quote(terms.gsub(/['?\\:]/, ' '))) textsearch = 'to_tsvector(\'simple\', tags.name)' - query = 'to_tsquery(\'simple\', \'\'\' \' || ? || \' \'\'\' || \':*\')' + query = 'to_tsquery(\'simple\', \'\'\' \' || ' + terms + ' || \' \'\'\' || \':*\')' sql = <<SQL SELECT @@ -26,7 +27,7 @@ class Tag < ApplicationRecord LIMIT ? SQL - Tag.find_by_sql([sql, terms, terms, limit]) + Tag.find_by_sql([sql, limit]) end end end |