hello all.
i currently have a simple search script that loops through the tables in my MySQL database searching for words LIKE whatever the search phrase is. it takes the form data, splits it into individual words, and checks the DB.
i have spent a couple days, with little success, trying to find a concrete example of an efficient way to remove stop words from the search query (a, and, the, for, where, etc.)
i have a .txt file containing hundreds of stop words. it is formatted like so:
[a][and][the][for][where][etc.]
could anyone suggest a simple method for comparing the contents of the .txt file to the search words and removing unwanted words before querying the DB?
it would even be helpful if i could just get pointed towards some sort of GPL project that already handles stop words so that i could decipher how it's being done...
thanks!
-dolphinsnot-
