Tuesday, August 28, 2012

how to swapping update query table row 0 to 1 and 1 to 0



mysql update query 1 to 0 and 0 to 1 single statement using query
update users set banned= case  when banned= "0"  then 1 when banned= "1"  then 0 end

No comments:

Post a Comment