Edit Bulk Field in database

[kronnos]

Hi,

Have a tricky question here and don't know if it can be done this way but maybe somebody might know.

Lets say in the users table I want to change all the active users (there is a field called active and options are yes and no) So to all users with Active=Yes I would want to change another field in those users, I would want files "type" to =1.

Basicly all Active and And Inactive users have a type=0 and I woudl want to change for active users for type to =1.

Can this be done without going through hundreds of users and changing these files one by one?

Thank You