Announcement

Collapse
No announcement yet.

Update Custom Profile Field En'mass

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

  • 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?
    Kind Regards
    Dave Hawley
    Excel Add-ins, Templates & Software
    Free MS Office Application Support

  • #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 field25 = 'NO'
    *Note: Make sure you have made a working database backup prior to running any custom.queries

    Comment


    • #3
      Thank you, Jose
      Kind Regards
      Dave Hawley
      Excel Add-ins, Templates & Software
      Free MS Office Application Support

      Comment

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