Query not returning result in fulltext search boolean modeeven though records exist
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.
Subject
Views
Written By
Posted
Query not returning result in fulltext search boolean modeeven though records exist
2990
July 18, 2013 11:02PM
1371
July 21, 2013 11:43AM
1327
July 21, 2013 09:35PM
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.