i'm trying to create a search engine on my database
i've created one fulltext index from 2 columns (object name and description)
when doing a query based on this index, the score of the returned matches is not what i expected to be
two words query (e.g. help please) returns the same matches like one word query (e.g. help)?!
and the scores are also the same?!
i don't think that's correct, what the mysql gurus think about this?
and my other question:
what should i do, when i would like to have the "name" column having a greater weight as the "description" column has, so when there are records in my table which look like this:
id name description
1 help please some text
2 help required some other text
and the searched string is "help please"
the score for record 1 is bigger than for the second one, even if there are both words in the description text of the record 2?
thanx
i've created one fulltext index from 2 columns (object name and description)
when doing a query based on this index, the score of the returned matches is not what i expected to be
two words query (e.g. help please) returns the same matches like one word query (e.g. help)?!
and the scores are also the same?!
i don't think that's correct, what the mysql gurus think about this?
and my other question:
what should i do, when i would like to have the "name" column having a greater weight as the "description" column has, so when there are records in my table which look like this:
id name description
1 help please some text
2 help required some other text
and the searched string is "help please"
the score for record 1 is bigger than for the second one, even if there are both words in the description text of the record 2?
thanx