Need a little MySQL/phpMyAdmin help

There is a setting "user_viewemail" that is either "0" or "1". It is within the "phpbb_users" table. I want to change user_viewemail to 0 for all records in the table. Is there a mysql command I can enter within phpMyAdmin to accomplish this? I think there is, but my grasp of MySQL is rather limited.

Here's a screenshot of the setting in particular within phpMyAdmin:
[IMG]http://home.eart*****.net/~kreativ/phpMyAdmin.gif[/IMG]

Thanks for your help!

 

 

 

 

Top