Использовать NOT:
SET show = NOT show;
UPDATE table SET boolean_field = NOT boolean_field WHERE id = :id