MySQL set NULL Query not always works

Question

UPDATE `table` 
SET `sent`='1', `taken`='1', `free`=NULL
WHERE `owner`='1' AND ISNULL(`sent`) AND !ISNULL(`free`);

Works, but set free to NULL not always works. Any ideas? Thx

Answer 1

UPDATE `table` 
SET `sent`='1', `taken`='1', `free`=NULL
WHERE `owner`='1' AND `sent` is null AND `free` is not null;

Answer 2

Check your triggers.

Answer 3

Execute the following query to check if it returns all the records you request:

SELECT *
FROM `table`
WHERE `owner`='1' AND ISNULL(`sent`) AND !ISNULL(`free`);