如何在mysql中添加levenshtein函数? [英] How to add levenshtein function in mysql?

问题描述

我以mysql形式"http://kristiannissen.wordpress.com/2010/07/08/mysql-levenshtein/"获得了levenshtein距离的代码，但是，如何在mysql中添加该函数?我正在使用xampp，我需要在php中进行搜索.

I got the code for levenshtein distance for mysql form "http://kristiannissen.wordpress.com/2010/07/08/mysql-levenshtein/" but, how to add that function in mysql? I am using xampp and i need it for search in php.

推荐答案

我已连接到我的MySQL服务器，并简单地执行了 MySQL Workbench 中的noreferrer>此语句，它确实起作用了-我现在有了新功能levenshtein().

I have connected to my MySQL server and simply executed this statement in MySQL Workbench, and it simply worked - I now have new function levenshtein().

例如，这可以按预期工作:

For example, this works as expected:

SELECT levenshtein('abcde', 'abced')

2

这篇关于如何在mysql中添加levenshtein函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！