Question for the SQL skilled

[Reddwarf]

Previously I had my recordings split over two drives (D:\NPVR and X:\NPVR), after building a new htpc I'v gathered all recordings on D:\NPVR. What sql statement should I use to change all instances of X:\ to D:\ in the whole database?

[mvallevand]

Previously I had my recordings split over two drives (D:\NPVR and X:\NPVR), after building a new htpc I'v gathered all recordings on D:\NPVR. What sql statement should I use to change all instances of X:\ to D:\ in the whole database?

Code:

UPDATE scheduled_recording SET filename = REPLACE(filename, 'X:\NPVR\', 'D:\NPVR\') WHERE filename LIKE 'X:\NPVR\%';

[Reddwarf]

Code:

UPDATE scheduled_recording SET filename = REPLACE(filename, 'X:\NPVR\', 'D:\NPVR\') WHERE filename LIKE 'X:\NPVR\%';

Thanks a lot, that saved me hours of manual editing

[martint123]

I'll keep a copy of that handy for future use I used to export to a text .sql file, search and replace and import from the text file