Snippet Name: Toggle a column bit regardless of state
Description: Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.
» Array of all US states
» FUNCTIONS: IF statement
» TABLE - Using Select Statement Wi...
» INDEXES: Bitmap Join Indexes
» INDEXES: Bitmap Indexes
» UPDATE: Update from a SELECT state...
» Inserting into SELECT statement
Highlight Mode: PHP
Last Modified: March 16th, 2009
// simple one-liner toggles the column 'ban_enabled' bit regardless of state
$toggle_sql = "UPDATE some_table SET ban_enabled = 1 - ban_enabled WHERE item_id = '$bid' LIMIT 1";