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. Also see:» Array of all US states » Toggle a column bit regardless of state » FUNCTIONS: IF statement » TABLE: Using Select Statement With Data » INDEXES: Bitmap Join Indexes » INDEXES: Bitmap Indexes » UPDATE: Update from a SELECT statement » Inserting into SELECT statement Comment: (none) Language: PHP Highlight Mode: PHP Last Modified: March 16th, 2009
Description: Toggle a column bit regardless of state. Useful to change state without doing a query first to detect the state of the bit.
Also see:» Array of all US states » Toggle a column bit regardless of state » FUNCTIONS: IF statement » TABLE: Using Select Statement With Data » INDEXES: Bitmap Join Indexes » INDEXES: Bitmap Indexes » UPDATE: Update from a SELECT statement » Inserting into SELECT statement
// 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";
