Query not returning result in fulltext search boolean modeeven though records exist

[shankar ganesh]

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.