ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Mass move members to different member group

August 08, 2014 3:53pm

Subscribe [2]
  • #1 / Aug 08, 2014 3:53pm

    randyrandy

    1 posts

    Is there a way to move a bunch (100+) members automatically from one member group to another? If not, can someone give a MYSQL statement that would do the above function?

    I am using EE 2.8.0.

    Thank you!

  • #2 / Aug 13, 2014 11:14am

    Rob Allen

    3118 posts

    Welcome to the forums

    SQL is fine but you need to find a variable that is unique to those 100 members, so it doesn’t update the other members as well!

    In all honesty I’d just manually update those members, it only takes a few seconds to do each one and you could easily do 5-10 in a minute if you focus on the task.

  • #3 / Aug 13, 2014 11:21am

    randyrandy

    1 posts

    Alrighty, thank you Rob.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases