Mysql toggle a field value

UPDATE `my_table` SET `my_field` = (SELECT CASE `my_field` WHEN ‘1’ THEN ‘0’ ELSE ‘1’ END) WHERE `my_table_ID_Field` = ‘1’

UPDATE `my_table` SET `my_other_field` = (SELECT CASE `my_other_field` WHEN ‘foo’ THEN ‘bar’ ELSE ‘foo’ END) WHERE `my_table_ID_Field` = ‘1’

Here is the test table

CREATE TABLE `my_table` (
  `my_table_ID_Field` int(11) NOT NULL auto_increment,
  `my_field` int(11) NOT NULL,
  `my_other_field` varchar(64) NOT NULL,
  PRIMARY KEY (`my_table_ID_Field`)
);

——Dumping data for table `my_table`—

INSERT INTO `my_table` VALUES(1, 0, ‘foo’);