Announcement

Collapse
No announcement yet.

Update Custom Profile Field En'mass

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

  • Guest's Avatar
    Guest replied
    Thank you, Jose

    Leave a comment:


  • Jose Amaral Rego
    replied
    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

    Leave a comment:


  • Guest's Avatar
    Guest started a topic Update Custom Profile Field En'mass

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X