MySQL Forums
Forum List  »  Full-Text Search

Question on working of Full text search index
Posted by: Sriram S
Date: September 21, 2007 06:50AM

Hi,

I am trying to figure out the way fulltext search index works.

I have a table which have 5 columns.
3 columns have been added into full text search index.

Here is the same data of 2 rows and the data belonging to the full text index columns:

1) Row 1

+-----------------------------------------------------
| mytable_caption
+-----------------------------------------------------
| MySQL is the greatest database server int he world!
+-----------------------------------------------------

| mytable_full_body
------------------------------------------------------------ ---+| The MySQL database server is the world's most popular open source database. Over six million installations use MySQL to power high-volume Web sites and other critical business systems - including industry-leaders like The Associated Press,Yahoo, NASA, Sabre Holdings and Suzuki. |

+-----------------------+
| mytable_title |
+-----------------------+
| MySQL Database Server |
+-----------------------+

Row 2

-------------------------------------------------------+
mytable_caption
----------------------------------------------------------
| PHP is a widely-used general-purpose scripting language that is especially sui
ted for Web development and can be embedded into HTML. |

---------------------------------------------------------

-------------------------------------+
| mytable_full_body
|
+----------------------------------------------------------- --------------------
-------------------------------------+
| PHP is the greatest web developing language in the world. PHP can perform func
tions that PERL performs on the web. |
+----------------------------------------------------------- --------------------

+-------------------------+
| mytable_title |
+-------------------------+
| PHP Hypertext Processer |
+-------------------------+

That ends the data in 2 rows for 3 columns.

Now I am using the below query to do a full text search.



SELECT mytable_id, mytable_title, mytable_caption, mytable_dts,
MATCH(mytable_title, mytable_caption, mytable_full_body)
AGAINST ('$searchstring') AS score FROM mytable
WHERE MATCH(mytable_title, mytable_caption, mytable_full_body)
AGAINST ('$searchstring') ORDER BY score DESC"


If $searchstring is mysql then my query returns with a score of
2.207764127185

But if $searchstring is php then the score is 0.
I am pretty sure that php is not in the stopword list of mysql.


I don't see any big difference between the 2 rows. One is about php and the other is about mysql.
I was expecting the same score for both.

Could someone throw light on this?

Thanks
Sriram

Options: ReplyQuote


Subject
Views
Written By
Posted
Question on working of Full text search index
6167
September 21, 2007 06:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.