Remove Attribute from all products?

[blindeyecreative]

I would like to remove an attribute from all products (600+) but I've run into an issue because it has a text value.

I see the option to remove an attribute from all categories but because the option value is a text box, it does not appear in the selection choices.

Is there a way to remove this option from all products without going through every product manually?

Thanks,
Jon

[blindeyecreative]

Like maybe with a PHP SQL patch or something?

(sorry to add this my last post was no longer able to be edited.)

[Ajeh]

In phpMyAdmin, test for:

SELECT from products_attributes WHERE options_id= XX and options_values_id =0;

where XX is the Options Name options_id ... are those the ones you want to delete?

[blindeyecreative]

The option ID is #65 and I want to remove it from all products.

There is no option value because it is text.

[Ajeh]

Backup your database first ...

After you have backed up the database ... run the command:

DELETE from products_attributes WHERE options_id= 65 and options_values_id =0;

[blindeyecreative]

Thanks. That worked perfectly.