Change stock levels

I need to change the stock levels for a bunch of products in the mysql database to unlimited

I'm worse than a newbie with working with the database. I need to change every product with the word manual to unlimited.

UPDATE `ifixma5_shopdata`.`jos_hikashop_product` SET `product_quantity` = '???' WHERE `jos_hikashop_product`.`product_id` =547;

Not sure what to place in the '???" for unlimited

Not sure how to format the syntax to have this run through the entire data base and only select products with manual in it.

Please be kind with your help, like a cut and paste mysql query string would be awesome.

Hi,

The value for unlimited quantity is "-1".
Actually in HikaShop there is the mass actions, they allow you to do this kind of things without writing any SQL requests.

You can reach them via the menu System > Massaction
www.hikashop.com/support/documentation/i...massaction-form.html