funny mysql issue i don't understand

Hi @JustJohnQ
and thanks a lot for your answer, too bad, i've tried and it doesn't work either
i'd already tried with set field = NULLwhere id = xx and field IS NOT NULL as i knew IS NULL or is not as conditions, i would have loved to see it work as a value but unfortunately, it doesn't
have a nice day