Announcement

Collapse
No announcement yet.

Looking for an SQL Query to replace text in signatures

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

  • Looking for an SQL Query to replace text in signatures

    This is the query I run to replace text in posts:

    Code:
    UPDATE post
    SET pagetext = REPLACE(pagetext,'OLD','NEW')
    What is the query to replace text in signatures?

    Thanks in advance.
    PNW Moto

  • #2
    Code:
    UPDATE sigparsed
    SET signatureparsed = REPLACE(signatureparsed,'OLD','NEW')

    Comment


    • #3
      You may need to empty the signature cache in AdminCP > Maintenance > Rebuid Counters afterwards.
      MARK.B | vBULLETIN SUPPORT

      TalkNewsUK - My vBulletin 5.6.2 Demo
      AdminAmmo - My Cloud Demo

      Comment

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