Mysql search design

Posted by neil on Stack Overflow See other posts from Stack Overflow or by neil
Published on 2011-01-05T18:49:28Z Indexed on 2011/01/05 18:54 UTC
Read the original article Hit count: 196

Filed under:
|
|
|

I'm designing a mysql database, and i'd like some input on an efficient way to store blog/article data for searching.

Right now, I've made a separate column that stores the content to be searched - no duplicate words, no words shorter than four letters, and no words that are too common. So, essentially, it's a list of keywords from the original article. Also searched would be a list of tags, and the title field.

I'm not quite sure how mysql indexes fulltext columns, so would storing the data like that be ineffective, or redundant somehow? A lot of the articles are on the same topic, so would the score be hurt by so many of the rows having similar keywords?

Also, for this project, solutions like sphinx, lucene or google custom seach can't be used -- only php & mysql.

Thanks!

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql