onedumbcoder Posted July 4, 2009 Share Posted July 4, 2009 I am executing this query but it is returning no results when it should be SELECT * FROM listing WHERE MATCH(title, description) AGAINST('er') I have no idea why, can someone please help me? Quote Link to comment https://forums.phpfreaks.com/topic/164774-match-against-not-working/ Share on other sites More sharing options...
fenway Posted July 4, 2009 Share Posted July 4, 2009 Fulltext searches are funny... if you don't have a very large sample dataset, or too many matches are found, it won't return anything. Quote Link to comment https://forums.phpfreaks.com/topic/164774-match-against-not-working/#findComment-868943 Share on other sites More sharing options...
onedumbcoder Posted July 4, 2009 Author Share Posted July 4, 2009 so what do i do? Quote Link to comment https://forums.phpfreaks.com/topic/164774-match-against-not-working/#findComment-868955 Share on other sites More sharing options...
fenway Posted July 5, 2009 Share Posted July 5, 2009 Sphinx is one option.... Quote Link to comment https://forums.phpfreaks.com/topic/164774-match-against-not-working/#findComment-869196 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.