Awaiting Email Activation to Valid

In myphpadmin run the following mysql query:

Code:

Select All

UPDATE xf_user
SET user_state = 'valid'
WHERE user_state = 'email_confirm';

To bulk move users awaiting email activation to valid.