# Full text search - acts\_as\_ferret, mysql

**URL:** <https://www.ruby-forum.com/t/full-text-search-acts-as-ferret-mysql/91957>\
**Category:** Rails\
**Created:** [April 13, 2007, 7:26pm UTC](https://www.ruby-forum.com/t/full-text-search-acts-as-ferret-mysql/91957 "2007-04-13T19:26:58Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jimache](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/c67d28/32.png) [@jimache](https://www.ruby-forum.com/u/jimache)\
**Post date:** [April 13, 2007, 7:26pm UTC](https://www.ruby-forum.com/t/full-text-search-acts-as-ferret-mysql/91957/1 "2007-04-13T19:26:58Z")

</div>

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,