11/12/2021

2021/12/11#p1
0 comments: click to read or leave your own

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.

cancel media
Leave a reply



Cancel comment

You can also:

Reply by email Reply by email Send a webmention Send a Webmention

2021/12/11#p2
0 comments: click to read or leave your own

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.

cancel media
Leave a reply



Cancel comment

You can also:

Reply by email Reply by email Send a webmention Send a Webmention

2021/12/11#p3
0 comments: click to read or leave your own

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?

cancel media
Leave a reply



Cancel comment

You can also:

Reply by email Reply by email Send a webmention Send a Webmention

Colin Walker Colin Walker colin@colinwalker.blog