Announcement

Collapse
No announcement yet.

help with a (styleid) sql query?

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

  • help with a (styleid) sql query?

    Hi,
    I'm hoping to make a sql query to update the styleid setting of all users where styleid = x. I'm a sql noob so this is a little over my head. Can anyone point me in the right direction?

    To beat the smartasses to the punch, I'll start:

    www.mysql.com

    thanks.

  • #2
    Check post #2 in this thread...

    http://www.vbulletin.com/forum/showt...tions-en-masse
    Lats...

    Comment


    • #3
      Thanks. I only want to update styles where the current setting = x though, I don't think that query will do it.

      Comment


      • #4
        UPDATE user SET styleid=y where styleid=x
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Thanks Steve... That's uh...a lot simpler than I thought it was going to be!

          Comment

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