Search through sentences

Question

I have a rails app and have decided to have a search. I have a search textfield and the controller takes care of everything. In my search method

def self.search(search)
    if search
      str = []
      search.split.each do |s|
        a = find(:all, :conditions => ['title or content LIKE ?', "%#{s}%" ])
        str = (str + a).uniq
      end

    else
      find(:all)
    end
  end

I want to be able to handle multiple word searches. If you remove the each...loop it works fine with 1 word searches. Anyways, I would like to find the related posts for each word that is searched and return a combination of that.

Ex. If someone searches "Greatest Player" it will return all instances of posts that have the title or content "Greatest" and any that have the title or content "Player"

score 6 · Accepted Answer · edited May 23 '17 at 10:34

6

You most likely should be looking at full text searching:

edited May 23 '17 at 10:34

Community

1
1

answered Apr 26 '12 at 04:19

Jeff Perrin

8,094
1
23
19

score 2 · Answer 2 · answered Apr 26 '12 at 04:18

2

Shouldn't it be

a = find(:all, :conditions => ['title or content LIKE ?', "%#{s}%" ])

answered Apr 26 '12 at 04:18

slowpoison

586
3
20

1

Or even better: `a = find(:all, :conditions => ['title LIKE ? or content LIKE ?', "%#{s}%", "%#{s}%"])` – Mischa Apr 26 '12 at 04:20
I was typing fast and made a typo, but that is not the point of the question. – Vasseurth Apr 26 '12 at 21:44
If it weren't a typo, it will exhibit the behavior you are describing. So, I'm just trying to help. – slowpoison Apr 26 '12 at 23:00

Weston Ganger · Answer 3 · 2014-07-04T05:36:25.450

2

All you needed was to change the find statement to Mischa's code and add a return statement

Working Code:

def self.search(search)
    if search
      str = []
      search.split.each do |s|
        a = where(title LIKE ? or content LIKE ?', "%#{s}%", "%#{s}%")
        str = (str + a).uniq
      end
    return str

    else
      find(:all)
    end
  end

edited Jul 04 '14 at 05:36

answered Dec 05 '13 at 19:23

Weston Ganger

6,324
4
41
39

:all is now deprecated instead we will now use a different method. a = where('title LIKE ? or content LIKE ?', "%#{s}%", "%#{s}%") – Weston Ganger Jul 04 '14 at 05:35
also change LIKE to ILIKE for case insensitive – Weston Ganger Jul 04 '14 at 05:37

Search through sentences

3 Answers3

Linked