Let mysql calculate levenshtein-distance

2005-11-14 Thread Horst Jäger
Hi, I have a nice little code snippet in pseudocode, which calculates the levenshtein-distance between 2 words. Is it possible to implement that code in mysql like in select word1,word2 from myTable order by dist(word1,word2 ) where dist is the function mentionend above which takes 2

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Jason Pyeron
yes, create a UDF. look at the mysql source for examples... On Mon, 14 Nov 2005, Horst [iso-8859-1] J?ger wrote: Hi, I have a nice little code snippet in pseudocode, which calculates the levenshtein-distance between 2 words. Is it possible to implement that code in mysql like in select

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Rhino
Sent: Monday, November 14, 2005 11:02 AM Subject: Let mysql calculate levenshtein-distance Hi, I have a nice little code snippet in pseudocode, which calculates the levenshtein-distance between 2 words. Is it possible to implement that code in mysql like in select word1,word2 from myTable

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Jason Pyeron
as your original query. Rhino - Original Message - From: Horst Jäger [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, November 14, 2005 11:02 AM Subject: Let mysql calculate levenshtein-distance Hi, I have a nice little code snippet in pseudocode, which calculates

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Gleb Paharenko
Hello. Probably, yes. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/stored-procedures.html http://dev.mysql.com/doc/refman/5.0/en/adding-functions.html Horst Jäger wrote: Hi, I have a nice little code snippet in pseudocode, which calculates the