Page 1 of 1
MySQL FullText Search
Posted: Wed Nov 16, 2005 6:27 am
by dibyendrah
Dear All,
I'm using MySQL FullText index for field which holds the large text. I tried the like query to search in this field and also used like conditions to test which is faster. Is the FullText Search better than like conditions or have their own benefits?
Regards,
Dibyendra
Posted: Wed Nov 16, 2005 6:39 am
by Burrito
Much different than the 'like' operator full text searches are. Return a very different set of results for very different search criteria full text searches will.
ex:
with like:
'....where field like '%I am Yoda%''
return any string that contains 'I am Yoda' this will... return any string that contains 'I am neat and my name is Yoda' this will not.
with fti:
'....where match ('I am Yoda') against....'
return any string that contains 'I am Yoda' this will... return any string that contains 'I am neat and my name is Yoda' this might.
see the differenece?
got some clue about full text search and implementing
Posted: Mon Nov 21, 2005 11:04 pm
by dibyendrah
Hi Burrito,
I got some clue about full text in mysql from you and thanks for that. Anyway, I'll be back after having the detail look at manaul.
Dibyendra
Posted: Tue Nov 22, 2005 12:36 am
by AGISB
If you got 1 table row with one large text the full text search will never get you anything. Only if you got many rows in the table you will get a result.
This is due to the fact that if mysql returns more than 50% of the rows in the search it renders it trivial. With one row you always get a trivial result.