views:

36

answers:

1

Sure, I can write a function for it in Python or something...but how can I do it in MYSQL?

WHERE title = "heart of darkness" more or less 3 characters...
A: 

A similar issue was discussed in this SO question, and here's a link from the accepted answer that presents a computation of Levenshtein distance in MYSQL.

Personally, however, I would avoid the stored-procedure approach and just implement it in the driving language (be it Python, PHP or whatever you use to interface the DB).

Eli Bendersky