ansaurus

Question

Answer 1

+1 A:

First, the keywords should be indexed so that it can be accessed faster.

Then you can do a fulltext search: http://en.wikipedia.org/wiki/Full_text_search Or, you could do a LIKE query: http://www.w3schools.com/SQL/sql_like.asp

Then, with those results, you just make the list of the related items.

joshli 2010-01-11 00:33:02

so I should store the keywords in separate columns?

Mark 2010-01-11 10:30:02

If you store them in seperate columns, the database would be slower and you would be able to use a LIKE query. If you use a just one column, you can use full text searches. Another solution is have individual rows for each keyword and this will be a faster method and easier to implement but it might be slower (this is what I would do).

joshli 2010-01-13 08:08:55

Answer 2

+1 A:

you can break up the title, description, keywords into tokens and then do a full text search in mysql on those keywords and order by relevance.

select * from article where match(title, description, keywords)
  against ('word1 word2 word3 word4' in boolean mode)
  order by relevance desc

http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html

jspcal 2010-01-11 00:34:34

ansaurus

tags:

views:

answers:

php - display links to related content

related questions