How to add levenshtein function in mysql?

mysql user-defined-functions levenshtein-distance
Sandesh Sharma picture Sandesh Sharma · Dec 17, 2012 · Viewed 31.9k times · Source

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.

Answer

mvp picture mvp · Dec 17, 2012

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

Related questions

How to call a MySQL stored procedure from within PHP code?

I have stored procedure that I created in MySQL and want PHP to call that stored procedure. What is the best way to do this? -MySQL client version: 4.1.11 -MySQL Server version: 5.0.45 Here is my stored procedure: DELIMITER $$ DROP FUNCTION IF …

Read More
Deterministic function in mysql

I got confused with a seemingly simple concept. Mysql defines deterministic function as a function that always produces the same result for the same input parameters So in my understanding, functions like CREATE FUNCTION foo (val INT) READS SQL DATA …

Read More
MySQL does not support recursive functions? why? since when?

I've written a stored FUNCTION that calls itself, recursively. However when I run it in a query I get this shameless error: Error: 1424 SQLSTATE: HY000 (ER_SP_NO_RECURSION) Message: Recursive stored functions and triggers are not allowed. "Not allowed"? …

Read More