## Melvin Davidson (melvin6925@gmail.com):
> UPDATE pcilms_assign
> SET intro = REPLACE (intro, 'HVACR1114_LAB_13A.pdf',
> '&file=HVACR1114_LAB_13A.pdf')
> WHERE intro like 'https://owncloud.porterchester.edu%'
> AND course=18 and id=55413;
Unfortunately, that tries to do the right thing for that example
only but does not account for the 200k documents not named
HVACR1114_LAB_13A.pdf.
> NOTE: DO NOT use % in front of 'https: <https://owncloud.porterchester.edu>
> It is not needed and will slow query performance.
And that will plainly not work if the string does not start with the
URL - as in the example given.
It even won't work regardless of version and OS.
Regards,
Christoph
--
Spare Space
