thanks a lot again. I am really a beginner.. and i am italian :p

I misunderstood this. "users awaiting email confirmation" is different than "users awaiting moderation". And I see you found the id in the admincp. Sorry, I thought you were confused, but it was me. :o

lol as i told you i am definitely a beginner and have a poor english.

Now:
UPDATE user SET usergroupid=eliminare WHERE usergroupid=3 AND email LIKE %sina.com%

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%sina.com%' at line 1

what happened?

Sorry, that's my fault. You need that in quotes, like:
But also, you can't have 'eliminare' there, because the usergroupid must be a number.

great! It worked.
Now i will want to go deeper...
Can i state something like "move all gmail.com account with more than 3 dots in the address"?

--------------- Added [DATE]1423324121[/DATE] at [TIME]1423324121[/TIME] ---------------

or like "everything with .pl suffix"?

So, 3 or more dots other than the one in 'gmail.com'? Maybe this:


and this

To be honest I'm not sure if trailing spaces are removed from emails addresses or not, so I don't know if you need a trailing '%'.

well this work great for registered users.
Will it work also for the quert in user awaiting email confirmation?

One more problem: it doesnt let me erase the users in the new group i created :( ("eliminare")

You just need to add "AND usergroupid=3" to the end.


What are you trying to do exactly?

i go to the erase/move users in the admincp, choose "eliminare" , it list about 5000 users, i flag them all but when i flag "erase" it says "action specified is not valid" and go back to the panel

--------------- Added [DATE]1423326747[/DATE] at [TIME]1423326747[/TIME] ---------------

well to tell the truth it doesnt allow me to move or erase the members of the group i created

Maybe it's too many to delete at one time. Maybe you can use the 'Join Date is Before' to try to select fewer at a time.