Announcement

Collapse
No announcement yet.

SQL Query Question

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

  • SQL Query Question

    I have a custom profile field which has a single selection menu of two options: Yes/No.

    It's field6

    How can I set everyone to the "yes" value?

    I know that there is the "set default" option, but I added this field months ago, and I assume that that option is only useful for when you first add the field?

    Thanks for any help!


  • #2
    Try this...
    Code:
    UPDATE
        userfield
    SET
        field6 = 'yes'
    WHERE
        field6 != 'yes'
    While you don't really need the where clause, it will show you how many didn't have it set to 'yes'. (just for info)
    Lats...

    Comment

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