unable to apply an SQL query update on table

[eran ariel]

Hi,

This is peculiar, as it functioned properly before, however, I am not certain what I might be missing in the syntax...

I am trying to update a table directly from myphpadmin as follows... the database is for a zen cart installation:

UPDATE `zenproducts` SET `product_is_call`= 1 WHERE `products_price`=0

I received the following:
0 rows affected. ( Query took 0.0125 sec )

there are about 6,000 rows in that table, and the condition exists...

I also attempted with the following syntax, however, I received the same result:

UPDATE zenproducts
SET product_is_call=1
WHERE products_price=0;

Any suggestions?



Edited 1 time(s). Last edit at 07/25/2013 08:19AM by eran ariel.