matching a search term?

[Mohammad]

hello buddies,
I have a full-text search to match a search term against an article TITLE and article TAGS. The tags are space delimited in a single field.

The results are less than stellar. I often find myself typing in an exact article title only to find it halfway down the page with less relevant articles at the top. if I could somehow order the results so that the closest matches to the title are most important, the relevancy problem would be fixed.

Here is the query I use now:

SELECT articles.articleTitle, articles.tags
WHERE MATCH (articleTitle, tags) AGAINST ('$search_term') -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Jan]

follow as given below:

SELECT articles.articleTitle, articles.tags, MATCH (articleTitle, tags) AGAINST ('$search_term') AS score
WHERE MATCH (articleTitle, tags) AGAINST ('$search_term')
Score is your ranking. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --