Forum Exporting locations with user data
 

Hello,
I found the query I need in order to extract the usernames and the email addresses of my forum, but how do I manage to extract also the location field? I looked at the user field but did not find any location field.

?? ;) thanks

SELECT username,email FROM user WHERE usergroupid='x';