Database query to list all users within usergroup?

[Ua|Eight]

If I wanted to export a list of users in usergroup id = 44, how would I go about that?

[ForceHSS]

Export them to where?

[ozzy47]

You can do that from phpmyadmin within your cpanel, by running this query:

SELECT * FROM user
WHERE usergroupid = 44

You can then export the list from there.

[Simon Lloyd]

You can do that from phpmyadmin within your cpanel, by running this query:

SELECT * FROM user
WHERE usergroupid = 44

You can then export the list from there.You can run that directly in admincp>maintainance>execute sql query and you'll get a list :) (don't forget to add any table prefix you use before "user" so maybe you use vb as the prefix and it would look like this

SELECT * FROM vb_user
WHERE usergroupid = 44

[ozzy47]

You can run that directly in admincp>maintainance>execute sql query and you'll get a list :) (don't forget to add any table prefix you use before "user" so maybe you use vb as the prefix and it would look like this

SELECT * FROM vb_user
WHERE usergroupid = 44

Right, but he won't be able to export it as he asked in the OP. :)

[Simon Lloyd]

Doh, should read more carefully :D

[ozzy47]

It happens to all of us at some point. :)

[Simon Lloyd]

This should help you export the results to csv http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/