@brennen hehe, well… it's a filename deep within a JSON field. I've pulled it out of that though (huzza for `json_each()`) and now want to extract a few bits of info out of the filename (e.g. the integer in `/.*No_?([0-9]+).*/`).
@samwilson ah, gotcha. that's a kind of string mangling i tend to do at the perl/python/php level, but it feels like there *ought* to be a way to do it in a query.
@brennen yeah, it looks like I'm heading back to PHP for it. At least then I'll be able to do some other things like open the files for other checking. I just liked the idea of a single SQL query solving all my problems at once!
@samwilson ah! hmm. how complex is the field?