[mythtv-users] Moving the location where my videos are stored...

Jesse tobor at berkeley.edu
Mon Dec 11 03:29:40 UTC 2006


On Sun, December 10, 2006 6:40 pm, George Nassas wrote:
> update videometadata
> set filename = insert(filename, 1, length('/old/path'), '/new/path')
> where filename like '/old/path%';

Yes, use that it's far superior. I didn't know about the insert()
function, is that a MySQL-specific construct?

Jesse.



More information about the mythtv-users mailing list