[mythtvnz] Correcting Title:subtitle listing

[Nick Rout]

I have a series of recordings of a programme called NZ Directs
(generally short films made by film students). The EPG has listed them
as having as title, eg, "NZ Directs: Wide Eyes". Listing as title =
"NZ Direct" subtitle = "Wide Eyes" would have produced the correct
result.

I'd like to run a script over my database to correct this, ie in pseudo-code

if title = "NZ Directs:*" then change record so title = "NZ Directs",
subtitle = $The_bit_after_the_colon (without the leading space)

However I have neither script-fu nor mysql-fu and throw it open to the
audience. I am language agnostic, as long as your solution doesn't
involve installing gigabytes of some obscure language. i.e bash, perl,
python or ruby solutions would be preferred.

Hads, this might be a candidate for epgsnoop to fix in the listings :)