2021/12/11#p1
Dave Winer asked about using a regex query "to do a simple replacement that's complicated by the constraint that it can't do the replacement inside an HTML element, only in text that's not."
I have exactly the same query for a very similar purpose (part of the search function) but with an additional complication of using it within a MySQL query where different regex rules apply.
2021/12/11#p2
It looks as though regex lookarounds aren't supported in MySQL queries (unless I'm missing something) so I'll have to settle with the current search query which returns a little more than I'd want.
2021/12/11#p3
Rewatching LOTR: The Fellowship of the Ring, I had to rewind the scene just as the hobbits enter Bree. I've never noticed before that Peter Jackson makes a brief cameo as a bedraggled resident of Bree munching on a carrot. A quick search later and it transpires that he had cameos in each of the LOTR series. How did I not know this?