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.