Searching a database

Chris Hickman wrote:

I realize this is an SQL problem but figured a lot of people using ROR have came across this before. I pulled apart the string that was entered into the search form and stored it in textArray. The problem I am having is when I include commmon words such as the, near, view and so on into the search field I end up with zero results. when I only search for less common words such as rocky and argentina for example the search works fine. at first I thought that maybe it was generating too many results and was screwing up but when i search for rocky it works and when i search for near rocky it doesnt.

You might want to look into using Ferret.

http://projects.jkraemer.net/acts_as_ferret/