MySQL Forums
Forum List  »  MyISAM

Query not returning result in fulltext search boolean modeeven though records exist
Posted by: shankar ganesh
Date: July 18, 2013 11:02PM

Hi,

In my website, I am using search box, the user has entered "d day" as keyword and its converted to "d-day" using php. In table I am having the field called seoTags, there the text d-day is exists, but my query is not returning result, but if I give "dhuaan-song" its returning, I don't know exactly why this is happening.

mysql> select title,seoTags from videos_videos where id = 82231;
+--------------------------------+----------------------------------------------------------------------+
| title | seoTags |
+--------------------------------+----------------------------------------------------------------------+
| D Day song Dhuaan witih Lyrics | d-day-dhuaan-song-arjun-rampal-irrfan-khan-rishi-kapoor-huma-qureshi |
+--------------------------------+----------------------------------------------------------------------+
1 row in set (0.00 sec)


mysql> SELECT video.id FROM videos_videos AS video where MATCH (seoTags,title) AGAINST ('"dhuaan-song"' IN BOOLEAN MODE) ;
+-------+
| id |
+-------+
| 82231 |
+-------+
1 row in set (0.00 sec)

mysql> SELECT video.id FROM videos_videos AS video where MATCH (seoTags,title) AGAINST ('"d-day"' IN BOOLEAN MODE) ;
Empty set (0.00 sec)

mysql> SELECT video.id FROM videos_videos AS video where MATCH (seoTags,title) AGAINST ('"day"' IN BOOLEAN MODE) ;
Empty set (0.00 sec)


Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Query not returning result in fulltext search boolean modeeven though records exist
1903
July 18, 2013 11:02PM


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.