Tag: sql
Posted in more
Mysql JSON – Retrieve the object (or just a key/pair) where key/value equals foo
Author: Steffy Alen Published Date: December 18, 2021
I’m using mysql 5.7 and I have a collumn (cars) whose value looks like: [ { “id”: 1, “model”: “bar” }, { “id”: 2, “model”:…
Posted in Tech
SQL REPLACE with Multiple [0-9]
Author: Steffy Alen Published Date: December 11, 2021
I have a string that I want to replace a group of numbers. The string contains groupings of numbers (and a few letters). ‘A12 456…