Update Custom Profile Field En'mass

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

    Update Custom Profile Field En'mass

    I have a Custom Profile Field (field25) that is a 'YES' or 'NO' single radio button choice.

    How can I update this field to 'NO' for ALL current members?
  • Jose Amaral Rego
    Senior Member
    • Feb 2005
    • 11058
    • 1.1.x

    #2
    Run Query to Mass Change *
    Selected User Profile Field 'Y' with new Selection / Option 'X'
    # replace vbb_ with your vB table prefix Example: [vbb_thread] if non leave blank
    # replace X with field to be edited
    # replace Y with New Radio Butoon Selection / Option

    Code:
    UPDATE `userfield` SET field[COLOR="Red"][B]25[/B][/COLOR] = '[COLOR="Blue"][I]NO[/I][/COLOR]'
    *Note: Make sure you have made a working database backup prior to running any custom.queries

    Comment

    • Guest

      #3
      Thank you, Jose

      Comment

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