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:
http://home.earthlink.net/~kreativ/phpMyAdmin.gif

Thanks for your help!

The following SQL will set user_viewemail to 1 for all records in the phpbb_users table:

UPDATE phpbb_users
SET user_viewemail = 1

Cool. :) As simple as that, huh? Thanks. :D I had thought I needed 'tinyint' somewhere in there.