Hi, ALL!

I have two tables in database.

t_article {
   title,
   content,
   author
}

t_friend {
  person_A,
  person_B
}

note that in t_friend is many-to-many relation。

When a logged-in user, search articles with a query word, 3 factors should
be considered in.
factor 1. relevency score
factor 2. if the article is posted by himself, give a higher score
factor 3. if the article is posted by it's friend, give a higher score

HOW can I boost factor 2 and 3?

Thanks very much!


-- 
梅旺生

Reply via email to