Reset value in MYSQL

Hello, i want to reset all values in column viewer_clicks from 1 to 0, what command should i run ?


When i click SQL, it have

SELECT * FROM `mmh_file_storage` WHERE 1

PHP:

 

try UPDATE mmh_file_storage SET viewer_clicks=0

 

If you want to change from 1 to 0 then use the following

UPDATE mmh_file_storage SET viewer_clicks=0
WHERE viewer_clicks=1;

Code (markup):

 

if you want to change the value from 1 to 0 in this field:

UPDATE mmh_file_storage SET viewer_clicks=0 WHERE viewer_clicks=1;

Thanks,

Jimmy

 

Which script is it?