Need a MySQL query to replace "custom" feature values with "predefined" feature values

[TWDesign]

So far as I can tell, when features are imported via CSV, they are imported as "custom" feature values.

 

If so, could somebody offer any advice on kind of SQL query I can run through myPHPadmin

in order to replace these "custom" features with the "predefined" feature values.

 

The filter module I am using (Ultimate Search) requires features to be "predefined" before it

can utilized checkbox filtering.

 

Any suggestions on mySQL query?

I really dont want to edit over 700 products manually.

[CartExpert.net]

Hi,

 

UPDATE [TABLE_NAME] SET [COLUMN] = [VALUE] WHERE [sOME_COLUMN] = [sOME_VALUE]

this will update only those rows where SOME_COLUMN's value is equal to SOME_VALUE

 

or

 

UPDATE [TABLE_NAME] SET [COLUMN] = [VALUE]

this will update all the rows

[TWDesign]

Thank you.

 

I'm a bit confused about how PrestaShop stores "predefined" feature values differently from "custom" feature values.

I really need to know that in order to work out the values of a MySQL update query.