Figuring out if 2 strings are similar in MySQL?

stszievb 于 2022-12-22 发布在 Mysql

关注(0)|答案(1)|浏览(121)

I have a table catalog_product_entity_varchar and a column value . I tried comparing strings with SOUNDS LIKE . That works well most of the time, but not for all cases.
Where it works: SELECT value FROM catalog_product_entity_varchar WHERE value SOUNDS LIKE 'Stechbeitel m.Schlagkappe 6mm';
This gives me other results such as Stechbeitel m.Schlagkappe 20mm , which is ok.
Another query however does not work: SELECT value FROM catalog_product_entity_varchar WHERE value SOUNDS LIKE '300 mm Hygiene Staender St.weissalu.';
Its supposed to find a string 300 mm Hygiene Staender St.schwarz , but it doesnt. Whats the reason here? I tried the soundex() values for 300 mm Hygiene Staender St.schwarz and 300 mm Hygiene Staender St.weissalu. and they are of course not the same, but almost the same, which makes sense. The soundex() values are M25235362324 and M252353623262 .
So, how could I either make the SOUNDS LIKE work for all similar strings or maybe match the soundex() values, as they are very similar?
Thanks!

mysql

来源：https://stackoverflow.com/questions/74873822/figuring-out-if-2-strings-are-similar-in-mysql

1条答案

按热度按时间

bfnvny8b1#

You could try to apply the SOUNDEX operator twice. The idea here is that similar strings will have slightly different soundex coding, but whose codes will have the same soundex sound.

SELECT value_ 
FROM catalog_product_entity_varchar 
WHERE SOUNDEX(SOUNDEX(value_)) = SOUNDEX(SOUNDEX(<your_comparison_string>))

Check the demo here .

赞(0）回复(0）举报 2022-12-22

我来回答

Figuring out if 2 strings are similar in MySQL?

1条答案

相关问题

热门标签

最新问答