The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
A query to remove rel= from homepage field?
Some time ago I installed a modification from vb.org (Two-Step External Links) 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. |
#2
|
|||
|
|||
This seems to work:
Code:
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). |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|