All geek questions in one place

Mysql compare strings

From a result set of 5 different lines, I would like to select a result from which the line looks more like my specified line. Is there any way to do this in mysql?

+3
source share
2 answers

It sounds like the perfect Levenshtein distance meter app .

It seems that there is at least one UDF implementation of this metric, which may have fallen from the Internet, and another SQL implementation .

+1
source

You may be able to achieve this using SOUNDEX

+2
source

Source: https://habr.com/ru/post/1730337/

More articles:


All Articles