If we need to toggle on a value, (for 1 to 0 and vice-versa for example), using a update, this is one solution…
UPDATE user SET profile_status = CASE WHEN profile_status = 1 THEN 0 ELSE 1 END WHERE user_id="1";
If we need to toggle on a value, (for 1 to 0 and vice-versa for example), using a update, this is one solution…
UPDATE user SET profile_status = CASE WHEN profile_status = 1 THEN 0 ELSE 1 END WHERE user_id="1";