Re^2: SQL: Update column(s) value with extra WHERE

Replies are listed 'Best First'.
Re^3: SQL: Update column(s) value with extra WHERE by Marshall (Canon) on Jul 17, 2023 at 09:40 UTC
Thanks! That is a good compilation of links. I use one application written in Ruby that uses MySQL. I have considered porting it to Perl and SQLite. I show the .sql file for the Jaro-Winkler algorithm below. Jaro-Winkler is similar to Levenshtein distance but it is optimized for short strings. Like maybe comparing license plates, radio callsigns, or something similar. There is a pure Perl algorithm implementation. But a C implementation built into the DB's work would run much faster. If I ever get a C program going, I could also make an XS Perl function. Jaro-Winkler.sql Read more... (4 kB)	[reply] [d/l]
Re^4: SQL: Update column(s) value with extra WHERE by karlgoethebier (Abbot) on Jul 17, 2023 at 10:44 UTC
From Text::JaroWinkler: Read more... (13 kB) «The Crux of the Biscuit is the Apostrophe»	[reply] [d/l]