Negation for searches

Rails
1

What is an efficient way to search for records that does not contain a
specific keyword.

e.g.

Find people where the state is not “MA” and first name contains “John”.

This should find:

John D. in NY
Johnston Ried in CA

But not:

John Swann in MA

I have been using my own search routines for this but they are not very
efficient. I’d like to upgrade it to something like
acts_as_fulltextable, Ferret, or Solr, but not sure which one is
suitable for what I need.

Thanks!

2

use sphinx with gem as thinking_sphinx
is super fast full text search engine
Best Regards, Dieinzige

On 23 Jun, 2010,at 09:39 PM, Thitsa M. [email protected] wrote:

What is an efficient way to search for records that does not contain a
specific keyword.

e.g

Find people where the state is not “MA” and first name contains “John”.

This should find:

John D. in NY
Johnston Ried in CA

But not:

John Swann in MA

I have been using my own search routines for this but they are not very
efficient. I’d like to upgrade it to something like
acts_as_fulltextable, Ferret, or Solr, but not sure which one is
suitable for what I need.

Thanks!

Posted via http://www.ruby-forum.com/.

–
You received this message because you are subscribed to the Google
Groups “Ruby on Rails: Talk” group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.