Thread

My situation is that I have a site with many members already created. After those members were created I’ve had to add an additional custom member field. All new member registrations will be required to fill in this field. But all old members have no value in this field.

There are too many old members to edit each one individually to add a field value, but it’s a required field so it must be done. Is there a way to edit them in bulk? I want all members in this one member group to have the exact same value in that field, so I’d like to find a way to change them all at once.

Is this possible in EE? Do I need to do a custom SQL query?

Any help would be greatly appreciated. I need to get this sorted out in the next few days.

Cheers,
Benek

Hey benek,

Thank you for posting your question.

I believe an SQL query is your best bet here. You are right. Just be sure to backup the database first! You never know what can happen. If you want I can move this to the Community Help Forum to see if anyone can help you craft that query.

Let me know!

Is there anything else I can help with?

Cheers,

Yes please move it I need help with the query

Hi Benek,

Have moved this thread to Community help at your request.

Sean

Thanks Sean.

Can anyone help me out writing a SQL query as described above?

Hi Benek,

you can run the sql query as

UPDATE exp_member_data, exp_members SET m_field_id_{field-id}='{value-need-to-be-updated}' WHERE exp_member_data.member_id=exp_members.member_id AND exp_members.group_id={group-id}

replace {field-id}, {value-need-to-be-updated} and group-id} according to your preference.

Hope this would help you.

That worked perfectly, thank you.