Update a field in WIX database

Ask the community
,
1

Is there a way to run a onetime SQL update on a WIX database.
I would like to run below query:

UPDATE [[databasename]] SET KEYWORD = TITLE

Any help will be appreciated.

2

You can’t run SQL on a Wix database, but you can add the code to a page’s onReady() function that loops through the collection and updates each row. Then after you run it, just delete the code.