## Melvin Davidson (melvin6925@xxxxxxxxx): > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
