Announcement

Collapse
No announcement yet.

Sql Query Needed

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

  • Sql Query Needed

    I have a forum where one of the users didnt port from phpbb and his posts are set to Guest

    All of the guys posts have his username typed in so i need a query to search for all his posts with X text and update each post to his new userID

    I can do the posts one by one with :

    UPDATE post SET userid='XXX' WHERE postid='XXX'

    But he has hundreds of posts - all with the common denominator of having X text string in each post so it would take HOURS if i did it manually

    Thanks
    Digital-Forums: www.digital-forums.com | CK3 Games: www.ck3.co.uk

  • #2
    Solved

    UPDATE vb_post SET userid='XXXX' WHERE pagetext LIKE "%XXXX%";

    Worked perfect
    Digital-Forums: www.digital-forums.com | CK3 Games: www.ck3.co.uk

    Comment

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