in reply to Re: SQL: Update column(s) value with extra WHERE
in thread SQL: Update column(s) value with extra WHERE

«…define a user function…»

Butter with the fish:

«The Crux of the Biscuit is the Apostrophe»

  • Comment on 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