find a data filed in a table

Hi,
I have added an extra data field in Community builder to be used in a list in conjunction with Mailster.

The data filed is a yes/no field for the users to choose if they wan to receive e-mails from the board.

The data field is defined as mandatory and for now only one user (me) has set the field. I need to auto update it for all the users.

My question is then, how do I find the table/filed in PHP admin ?

And second, is it an easy task to update the field to a default value ?

Thank you in advance.
Ole Bro

Easiest way to mass one time update users like that is to just directly do it in the database. Specifically the _comprofiler table. You should see a column there with the same name as your field.