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
» 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
Comment: (none)
Author: CoderZone
Language: PHP
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"; |
