c_shelswell Posted September 27, 2009 Share Posted September 27, 2009 bit of a strange one. I had been getting results from this now all of a sudden i'm not. The query is working without errors it's just not returning. Here's the sql SELECT * FROM products WHERE MATCH(item_title, description) AGAINST ('saddle') Full text search is on and the word is in both the item_title and description. I'm just not getting anything back. Don't suppose anyone has any ideas? Cheers Link to comment https://forums.phpfreaks.com/topic/175690-mysql-match-query-stopped-returning-results/ Share on other sites More sharing options...
fenway Posted October 5, 2009 Share Posted October 5, 2009 Full-text searching will ignore any keywords that match more than 50% of the records. Link to comment https://forums.phpfreaks.com/topic/175690-mysql-match-query-stopped-returning-results/#findComment-930744 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.