Why can't I delete these records?

[Evert]

Hi all!

Who can tell me why the following does not work...?

When I do:
SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND 
condition2 IS NULL;

it returns:
+---------+
| counter |
+---------+
|       2 |
+---------+

Then I do:
DELETE FROM table1 WHERE condition1 = 'A' AND condition2 IS NULL;

it returns:
Query OK, 0 rows affected (0.00 sec)

But... when I give a
SELECT COUNT(*) AS counter FROM table1 WHERE condition1 = 'A' AND
condition2 IS NULL;

How come the 2 records did not get deleted...?

Regards,
   Evert