Finding "similar" results of find_all

rubyonrails-talk
1

Hi :slight_smile:

I need to make something like a search engine, this means I post a query like "cat" and I'd like rails to find all rows with specified field containing this word, like "black bat", "catwalk" and so

Is there any other option than :condition => ["content LIKE %?%", search_mask] ???

Thank you in advance :slight_smile:

2

Hi :slight_smile:

I need to make something like a search engine, this means I post a query like "cat" and I'd like rails to find all rows with specified field containing this word, like "black bat", "catwalk" and so

Is there any other option than :condition => ["content LIKE %?%", search_mask] ???

Thank you in advance :slight_smile:

3

More generally a full text search engine (mysql's builtin one, sphinx, ferret etc...) will be more powerful than mashing things around with Like and %. (some will do stemming and things like that as well)

Fred