Welcome Guest, Not a member yet? Register   Sign In
How do I.. fuzzy search requirements?
#1

[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?
#2

[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.




Theme © iAndrew 2016 - Forum software by © MyBB