mysql query and &

[faust]

Can anybody tell me what & means in an SQL query. Example:

Code: Select all

SELECT blabla
FROM blabla
WHERE id = 5 AND flag&2=2


[Nullsig]

When the ampersand (&) is used like this in a query it is a "Bitwise AND":

Code: Select all

http://dev.mysql.com/doc/refman/5.0/en/bit-functions.html#operator_bitwise-and

In this case it is saying that if the binary translation of your "flag" variable ends in "10" [Binary 2] it will return true.

In the example in the link I shared the values are
11101 (29)
& 1111 (15)
1101(13)