How do I.. fuzzy search requirements? |
[eluser]SomeFunkyDude[/eluser]
slowgary suggested I do this so here it goes... I'm trying to search a database for 30k+ entries using the database classes db->or_like method. The disadvantage to this, is the match has to have ALL the characters I'm searching for. So if I search for something spelled incorrectly, it won't return the result. I'm sure there's a way to use regex to search and destroy what I'm looking for, but is there a better method I could use, is there a CI class method that can perform less restrictive search results?
[eluser]TheFuzzy0ne[/eluser]
Saw the title, and figured I should make an appearance. After all, who'd know more about "fuzzy stuff" than me? MySQL natively supports fuzzy logic, but you need to have a full text index and use MATCH AGAINST - http://www.yvoschaap.com/index.php/weblo...lts_found/ You could also try [url="http://framework.zend.com/manual/en/zend.search.lucene.html"]Zend Search Luecene[/url], if you want to have this ability cross platform. |
Welcome Guest, Not a member yet? Register Sign In |