A query to remove rel= from homepage field?

[Alfa1]

Some time ago I installed a modification from vb.org (Two-Step External Links (https://vborg.vbsupport.ru/showthread.php?t=217708&highlight=step)) and this caused many of my member homepage field to have 'rel=' added to the end. I removed the modification but my database still has this.

Is there a way to remove this by query. It would also be ok to just remove all member websites from that database field that have 'rel=' added to it.

[kh99]

This seems to work:

UPDATE user SET homepage=SUBSTR(homepage, 1, LENGTH(homepage) - 4)
WHERE SUBSTR(homepage, -4) = 'rel='


You need to add your table prefix to 'user' (if you have one).

(I tried this on a small test db with one record that matched, but if I were doing it for real I'd probably back up that table first).