SQLite: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
(Created page with "The SQLite connector has the Levenshtein function! A couple of examples: <source lang="mysql"> SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' ) </source> Result...")
(No difference)

Revision as of 02:43, 31 December 2015

The SQLite connector has the Levenshtein function! A couple of examples:

SELECT LEVENSHTEIN( 'Microsoft', 'Technology Advisors, Inc.' )

Result: 21

SELECT LEVENSHTEIN( 'Technology Advisors Inc', 'Technology Advisors, Inc.' )
</source
Result: 2
<source lang="mysql">
SELECT LEVENSHTEIN( 'Bob', 'Tom' )

Result: 2