MySQL Help - Need to delete a product

[suhailc]

Hi,

 

MySQL is one of my weak points, and I was hoping someone could help with the MySQL code to run two commands on a WHMCS db.

 

I've imported a MB db into a WHMCS db, and along with valid products/services, it has also imported some odd "previous balance" thing which has been setup as a product/service on all accounts.

 

I would like to:

 

1.) Switch the product status from "active" to "terminated" for all clients who have it setup for them.

2.) Delete it as a product/service for all clients who have it setup as either "active" or "terminated".

 

I hope someone can assist.