Toggle boolean

[ehsanonline]

is there a way to update a bool type value by toggling? example: update $th set is_admin=!is_admin;

[AL1L]

I looked through the documentation and even tried some things and I can't find a specific operator or function to invert a boolean...

For now you can do a compaison against false which should do the trick

UPDATE user:asdf SET is_admin = (is_admin == false);

Something funny I found is this is also valid, but not as strict, but you could use it if is_admin might not be a boolean.

UPDATE user:asdf SET is_admin = (is_admin = false);

As a double == is a strict equals.

Also, the perentesis aren't required, but I think it makes the code easier to read.