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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.