Skip to content

Harry Bailey

Mentor and Agility Coach from Manchester, UK

Posted on Tuesday, April 27, 2010Thursday, January 3, 2019 by harrybailey

MySQL Toggle a Fields Value

UPDATE `table_name` 
SET `field_name` = (SELECT CASE `field_name` WHEN 1 THEN 0 ELSE 1 END) 
WHERE `id_column` = 1

Or with text strings

UPDATE `table_name` 
SET `field_name` = (SELECT CASE `field_name` WHEN 'foo' THEN 'bar' ELSE 'foo' END) 
WHERE `id_column` = 1

Share this content:

  • Print
  • Twitter
  • LinkedIn
  • Facebook
  • Reddit
  • Pocket

Related

CategoriesMySQL

Post navigation

Previous PostPrevious More powerful jQuery getScript with cache control
Next PostNext Pimping Fancybox jQuery Lightbox

Recent Posts

  • Offboarding as a priority
  • Fuelling Your Team
  • Continuous Universal Improvement
  • Encouraging Digital Meeting Promptness
  • Being outranked for your own name in search engines

Other profiles

  • Twitter - @HarryBailey
  • Medium - /@harrybailey
  • LinkedIn - /harrybailey
  • YouTube - /harrybailey
  • Instagram
  • Mastodon - @HarryBailey

Categories

  • Growing
  • Self
  • Tech
    • Amazon Web Services (AWS)
    • Apache
    • cPanel
    • CSS
    • Design
    • Facebook
    • Git
    • Google
    • IFTTT
    • Javascript
    • jQuery
    • Mac
    • Mac apps
    • MySQL
    • PHP
    • React Native
    • SQL
    • Twitter
    • Web Cookies
    • WHM
    • Wordpress
    • WorldPay
    • Yii

Archives

  • September 2022
  • January 2022
  • November 2021
  • September 2021
  • July 2021
  • June 2021
  • April 2021
  • November 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • January 2020
  • December 2019
  • November 2019
  • September 2019
  • July 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • August 2018
  • March 2018
  • August 2015
  • April 2013
  • December 2012
  • September 2012
  • August 2012
  • July 2012
  • May 2012
  • March 2012
  • February 2012
  • November 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
  • September 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • March 2010
  • February 2010
  • January 2010
  • December 2009
  • October 2009
  • September 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008

Copyright Harry Bailey 2010-2020

Proudly powered by WordPress