Negation for searches

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


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

This should find:

John Doe 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.


use sphinx with gem as thinking_sphinx

is super fast full text search engine

Best Regards, Dieinzige