MySQL Match Against relevance issue...

Discussion in 'PHP' started by sub7, Oct 28, 2010.

  1. #1
    Basically when searching like this: "Pendulum - Slam" (which is an author - title) my sql results are relevant to pendulum but not to slam even though slam is in the db, surely it would make it more relevant that all words appeared in the entire row? Apparently not...
    I also search for tracks just with the title (slam) and nothing appears at all. It's as if the fulltext index just ignores the title column... but why?

    Here is my query:

    SELECT *, MATCH(title,author,tags,album) AGAINST('$q') AS relevance FROM tracks WHERE MATCH(title,author,tags,album) AGAINST('$q') AND enabled = 1 ORDER BY relevance DESC LIMIT 30 OFFSET 0
    Code (markup):
     
    sub7, Oct 28, 2010 IP