Setting a bitwise column with jooq in mysql

Question

I'm trying to do a bitwise operation while setting a column using JOOQ and MySQL. The statement I'm trying to convert to JOOQ is:

UPDATE users SET permission = permission | 16;

Is there a way todo this in JOOQ?

Answer 1

Use DSL.bitOr()

ctx.update(USERS)
   .set(USERS.PERMISSION, bitOr(USERS.PERMISSION, 16))
   .execute();