coolbeansdude51 Posted December 26, 2008 Share Posted December 26, 2008 Hello forum, I have an application which deals with quotes. They have to be short (140 characters or less) and so far I haven't been running into the problem of duplicates until now. I am wondering if anyone knows of a open source project or any other code out there that basically searches the a field in a database and compares it to this new entry and returns how alike it is based off a percentage. For example: Someone would want to submit a quote like "Business is fun." the script would then search the database and try to find other entries in the field that had the sames words. It then returns how "unique" it is based off a percentage of the words that are in the quote and in the other quotes in the database. Does that make sense? Anyone have any ideas? Thanks for your help! -Adam Quote Link to comment https://forums.phpfreaks.com/topic/138498-duplicate-entry-question/ Share on other sites More sharing options...
Mchl Posted December 26, 2008 Share Posted December 26, 2008 Did you look at FULLTEXT search available for MyISAM tables? http://dev.mysql.com/doc/refman/5.1/en/fulltext-natural-language.html Quote Link to comment https://forums.phpfreaks.com/topic/138498-duplicate-entry-question/#findComment-724161 Share on other sites More sharing options...
coolbeansdude51 Posted December 27, 2008 Author Share Posted December 27, 2008 Interesting. Looks like it will do everything I want! I will try it out. Any other suggestions? Quote Link to comment https://forums.phpfreaks.com/topic/138498-duplicate-entry-question/#findComment-724614 Share on other sites More sharing options...
fenway Posted December 29, 2008 Share Posted December 29, 2008 Sphinx? Quote Link to comment https://forums.phpfreaks.com/topic/138498-duplicate-entry-question/#findComment-725703 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.