Announcement

Collapse
No announcement yet.

How to change old domain links in all posts

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change old domain links in all posts

    Dear All

    I have changed my domain name from .co.uk to .org

    Sometime when a member asks a repeated question in the forum we put the link of the thread related to the question.

    Now all these links in all posts will be invalid due to the domain change.

    I searched the database using Phpmyadmin and found around 1000 link related to the old name of my site.

    Is there any way to change all posted links in the forum, I believe this could be through the database itself.

    Appreciate your help

    Thank you

  • #2
    Try this query...
    Code:
    UPDATE post
    SET pagetext = replace(pagetext,'OLDURL', 'NEWURL') 
    WHERE pagetext
    LIKE '%OLDURL%'
    Lats...

    Comment


    • #3
      That is great,
      Thank you

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X