Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the value (1 or 0) of a specified bit in a bit array.
GET_BIT( bit-expression, position )
The bit array containing the bit.
The position of the bit for which to return the status.
The positions in the array are counted from the left side, starting at 1.
If position exceeds the length of the array, 0 (false) is returned.
The following statement returns the value 1:
SELECT GET_BIT( '00110011' , 4 );
The following statement returns the value 0:
SELECT GET_BIT( '00110011' , 5 );