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 &

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Jason Pyeron
On Mon, 14 Nov 2005, Rhino wrote: If you are asking whether MySQL already has a function that will calculate a levenshtein-distance, I'm pretty sure that the answer is no. You can check the MySQL manual yourself to be sure. The (English language manuals are at http://dev.mysql.com/doc

Re: Let mysql calculate levenshtein-distance

2005-11-14 Thread Rhino
If you are asking whether MySQL already has a function that will calculate a levenshtein-distance, I'm pretty sure that the answer is no. You can check the MySQL manual yourself to be sure. The (English language manuals are at http://dev.mysql.com/doc/ and other translations of the manual

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 "s

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 whi

Levenshtein

2004-02-16 Thread Hakon Gunsen
When will Levenshtein algorithm be availble in mySQL? I know that there are some UDF's but I find them awkward to install. Is there a special reason that this isn't included in MySQL? Are there license fees or what? At least the algorithm seems most simple. ..Hakon