BigHugger
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…

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