SQL – DOB blog

MySQL/MariaDB Split Comma Separated String Into Table

root2019-11-112019-11-11

As you know, in MySQL/MariaDB there is no native function for splitting string column by comma or by some regex into a table. In PostgreSQL we a great function regexp_split_to_table for this, but in mysql compatible world it was not possible (till some time ago) to do this without complicated workarounds. Fortunately with introduction of […]

MySQL JSON diff

root2017-10-222019-11-11

Simple function that compares two JSON structures (on 1st level only), and returns old values for changed keys. I’m using it to track table changes via before update trigger.