Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Maziar Aflatoun
May 16, 2005, 12:13 am
rate this thread
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?
Re: PHP MySQL
Fulltext would be the best otherwise what you can also do is make a
search table for it.
Basically it is a word list that associates the amount of times the word
is found, the word itself and the article it is associated with. As for
doing phrases fulltext is the best bet.