rows - Change all records at once. Update one field with same input mysql -

i trying change input 1 field of records though can't figure out. appreciated.

i trying change them using:

select * `users` set 'password'='newpassword'; 

update proper command changing values in mysql - example:

update `users` set password='new_password_string' password not null