full text search - acts_as_ferret, mysql

Hi everyone,

I started developing an app that at some point will recevive as input param a file containing an article (txt, .doc ... not sure yet). And based on some predifined words, sentences, phrases (stored in a table) I want to be able to assign a score to the received article. This is going to be my first project of this type so, any ideeas on how to pursue this?!?!... -- how should i store the predifined term (words, senteces, phrases), each term per record (in tblterms)... one record and all the term in blob field?!!?

... anyone worked in something similar?! All and any help is appreciated.

Thank you,