This may be basic, but I'm a n00b.
I recently installed vBulletin 3.7. Shiny. I then IMPEX'd a phpBB 3.0 forum.
However, after IMPEXing, vBulletin nastily added text in some places. Particularly to links. So, all the links people posted are now in the form of ...
[url=http://server.com.randomletters]Link[/url.randomletters]
I'd like to run an SQL query to find and replace ...
.randomletters]
with just ...
]
(At least for this example. I've also got other text mishaps.)
I have found a bit of SQL code in another thread ...
UPDATE post
SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')
But this would only replace specific fulltext, not a random snippet where the only constants are "." at the beginning and "]" at the end, like I'm wanting.
I'm sure there are a few variables that I could use to change 'OLD TEXT' and 'NEW TEXT', but I'm a n00b and my Google-Fu is lacking for this.
Thanks in advance!
I recently installed vBulletin 3.7. Shiny. I then IMPEX'd a phpBB 3.0 forum.
However, after IMPEXing, vBulletin nastily added text in some places. Particularly to links. So, all the links people posted are now in the form of ...
[url=http://server.com.randomletters]Link[/url.randomletters]
I'd like to run an SQL query to find and replace ...
.randomletters]
with just ...
]
(At least for this example. I've also got other text mishaps.)
I have found a bit of SQL code in another thread ...
UPDATE post
SET pagetext = REPLACE(pagetext,'OLD TEXT','NEW TEXT')
But this would only replace specific fulltext, not a random snippet where the only constants are "." at the beginning and "]" at the end, like I'm wanting.
I'm sure there are a few variables that I could use to change 'OLD TEXT' and 'NEW TEXT', but I'm a n00b and my Google-Fu is lacking for this.
Thanks in advance!
Comment