How can set/where Bitwise Operators

[LH-gulongfei]

I want
update table set tag = tag | 2 where tag & 2 = 2

[andruet]

Have you found a solution? I encountered the same problem.

[jeffgbutler]

You should be able to code your own functions for bitwise operators. You can use the included functions as examples: https://github.com/mybatis/mybatis-dynamic-sql/tree/master/src/main/java/org/mybatis/dynamic/sql/select/function

[andruet]

Why not directly support these common operations? Or a simple construction method for these common operations.

[LH-gulongfei]

Have you found a solution? I encountered the same problem.

public SqlColumn bitEquleTo(SqlColumn column, int bit){
return SqlTable.of("dynamic").column(String.format("%s & %s"),column.name(), bit),JDBCType,INTEGER);
}

demo:
// select * from table where flag & 4 = 4
mapper.select(x -> x.where(bitEqualTo(flag, 4), isEqualTo(4))