It's worth running a quick SELECT with the same WHERE clause, before you run the update so you can see the records that will be affected by the UPDATE.
For example:
SELECT * FROM Pcash WHERE field = 1000000