PHP and MySQL Searching TEXT Field

Hi everyone,

I'm designing an application and have field defined in a table as Text where
I store Articles. I need to search the contents of my field for specific
keyword phrases for all the rows (5000+ rows). What is the best method to
do this? Should I use indexes or FullText? Also with indexes what would be
the best Key size?

Thank you
Maz.

Hello Maziar,

The short answer is yes.

As in the example I supplied to you on may 18th.

This example came from MySQL.com @
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
which describes in detail what you want to know.

Good Luck.

Joseph Melnick
JM Web Consultants
http://www.jphp.com/




"Maziar Aflatoun" <maz00@rogers.com> wrote in message
news:HLydnQ5wU8FLShrfRVn-oA@rogers.com...
> Hi everyone,
>
> I'm designing an application and have field defined in a table as Text
> where
> I store Articles. I need to search the contents of my field for specific
> keyword phrases for all the rows (5000+ rows). What is the best method to
> do this? Should I use indexes or FullText? Also with indexes what would be
> the best Key size?
>
> Thank you
> Maz.
>