Moving secondary usergroup to new primary usergroup

[Merriweather]

I want to move all members of secondary usergroup X to primary usergeroup A. However, prune/move users doesn't seem to have the option of searching by secondary usergroup. Is there another way?

Also, I would like to change all paid memberships to a new paid subscription I created. So I'd like all subscribers to X, Y or Z to now have a subscription to B with the same expiration that their old subscription had. Is there any way to do this?

[Marco van Herwaarden]

Both questions: no

PS Never try to manual changes a paid subscription, this will lead to problems.

[Merriweather]

Actually, I did it. I did it manually with a few find and replace statements in MySQL and made sure to cancel all recurring PayPal subscriptions so they had to re-subscribe to the new subscription I created.

I've had users renew since the change with no problems. :)

[jeepnchris]

[QUOTE=Merriweather;1759142]I want to move all members of secondary usergroup X to primary usergeroup A. However, prune/move users doesn't seem to have the option of searching by secondary usergroup. Is there another way?
[QUOTE]

I need to do this part. Do you have the SQL code you used?

Thanks in advance!
Chris