checking coloumName value before update. if value of coloumName = 1 then 0,if coloumName = 0 then 1.

UPDATE `tableName` SET `couloumName`= IF(coloumName=1,0,1) WHERE id = Idvalue

Comments

Popular posts from this blog

Enable the imap in support in xampp server