课程: Intermediate SQL for Data Scientists

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Fuzzy string matching

Fuzzy string matching - SQL教程

课程: Intermediate SQL for Data Scientists

开始一个月试用 购买团队方案

Fuzzy string matching

“

- [Narrator] When we're working with texts, sometimes we want to be tolerant of small variations in a text. For example, if we're using single words and we're trying to match on those, maybe there's a typo and maybe there's an extra S for example, like at the end of the word Postgres, well, if somebody has two S's at the end of Postgres versus one, do you want to be able to match on that column? Well, sometimes the answer's going to be no, absolutely not. Those are two distinct values. But then there are other use cases that have different requirements, and you might want to be tolerant. But when you want to be tolerant about how you match on texts, it's helpful to use some functions that are available in a Postgres extension known as fuzzystrmatch. And to use this, we need to enable the extension. Now, extensions in Postgres are like libraries of code that are available with the Postgres code, but not necessarily installed by default. And so what we do is when we want to use an…

内容