Product alias

[eboons99]

Hi,

Can i update the database on the field product alias ? can not find it in any table...

want empty the field, so virtuemart will put the productname, should it work ? 

i use joomla 3 and virtuemart 3

thnx

[Milbo]

product alias is called slug in the db

[eboons99]

Thnx

i want to update this field for the entire product tabel, i tought something like this would do the the trick, but facing an error
UPDATE `cs5aq_virtuemart_products_en_gb` SET `slug`= NULL where 'slug' IS NOT NULL

any idea's in how to this will work?

thnx