MySQL, multiple BIT operations in one column

Question

I have column named settings (type: tinyint unsigned not null).

That contains user settings in bits (0/1).

For example when i want update setting_1 then i do:

UPDATE `users` SET `settings`=`settings`|1

(That sets setting1 to 1 (true) ).

But, how i can do multiple update one column? For example:

UPDATE `users`
SET
 `settings`=`settings`|1,
 `settings`=`settings`&~2,
 `settings`=`settings`|4
WHERE `user`='xyz';

Any links that explain it?

Darshan Mehta · Accepted Answer · 2016-03-11 00:14:20Z

2

You can perform all the operations together, e.g.

update user 
set settings = settings|1&~2|4;

You can also use brackets to limit the scope. Here is the SQL Fiddle for same.

answered Mar 11, 2016 at 0:14

Darshan Mehta

31k14 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1