Mysql compare Strings

Question

from a resultset of about 5 different strings, I would like to select the result of which the string resembles my given string the most. Is there any possibility to do this in mysql?

If you can show us the strings.. it would help a little

Angel.King.47
– Angel.King.47

2010-01-28 08:09:42 +00:00
Commented Jan 28, 2010 at 8:09 — Angel.King.47
– Angel.King.47, Commented Jan 28, 2010 at 8:09

David Hedlund · Accepted Answer · 2010-01-28 08:14:39Z

2

You might be able to achieve this using SOUNDEX

answered Jan 28, 2010 at 8:14

David Hedlund

130k33 gold badges205 silver badges223 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Frank Shearar · Accepted Answer · 2010-01-28 09:00:08Z

1

This sounds like the perfect application of the Levenshtein distance metric.

It appears that there is at least one UDF implementation of this metric, which may have fallen off the web, and another SQL implementation.

answered Jan 28, 2010 at 9:00

Frank Shearar

17.2k8 gold badges72 silver badges96 bronze badges

Collectives™ on Stack Overflow

Mysql compare Strings

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related