+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How do I.. fuzzy search requirements? (/showthread.php?tid=17780)
How do I.. fuzzy search requirements? - El Forum - 04-15-2009
[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?
How do I.. fuzzy search requirements? - El Forum - 04-15-2009
[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/weblog/easy_fuzzy_logic_with_mysql_the_end_of_no_results_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.