sk Skill · maxrave-dev
like-wildcard-escaping-ids
Matching a machine-generated id inside a text or JSON column with LIKE — why _ and % in the id silently widen the match, how to escape them with nested replace() plus an explicit ESCAPE character, and why the id must be matched as a quoted token rather than as a bare substring. Reach for it when a cleanup spares rows it should have deleted, when a lookup returns a row belonging to a different id, or before putting…
Open on skills.sh ↗read 2026-09-17
- installs 8w
- 0
- 30-day movement
- starts with the next reading
- Related entries
- 1
- Connections
- 0
sql
- Host repository
- maxrave-dev/kotlin-footguns
- Host stars
- 479