Update prices per category not working

I'm trying to update the prices per category with:

UPDATE products SET products_price = products_price = x.xx WHERE master_categories_id = xx;

But the prices are not updated after the insertion. The price fields are blank.
I just want to set a price, not % or such.

Any suggestions?
Thanks

pascal020:

I'm trying to update the prices per category with:

UPDATE products SET products_price = products_price = x.xx WHERE master_categories_id = xx;

But the prices are not updated after the insertion. The price fields are blank.
I just want to set a price, not % or such.

Any suggestions?
Thanks

Have you tried:

UPDATE products SET products_price = x.xx WHERE master_categories_id = xx;

And is it that you are trying to make all items have the same price, correct?

By-the-way, backup your database before using the above suggestion. It should result in a change of products_price, but wouldn't want something to go wrong and not be recoverable.

mc12345678, it is working :)

Yes, same prices in the category and yes, I always backup before making changes to the database.

Many thanks