MySQL Forums :: MyISAM :: Query not returning result in fulltext search boolean modeeven though records exist


Advanced Search

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 1865 shankar ganesh 07/18/2013 11:02PM
Re: Query not returning result in fulltext search boolean modeeven though records exist 959 Rick James 07/21/2013 11:43AM
Re: Query not returning result in fulltext search boolean modeeven though records exist 912 shankar ganesh 07/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.