Updating Bitmasks Using Simple SQL Statement
An often useful technique for storing options is to use bit masking to identify if a particular option is enabled or disabled. A contrived example (and this is a poor example!) might be a ATM that allows control of what options are available to the user.
Eg.
1 – Chequing
2 – Savings
4 – Credit Card
8 [...]