'How to add a list to DB Browser for SQLite

I have data that follows:

vocab   phonetictranscription_bre   phonetictranscription_ame
little           ˈlɪtl                       ˈlɪtəl
settle           ˈsɛtl                       ˈsɛtəl
...

If the word is in the list below, I want to change every 't' symbol in phonetictranscription_ame with the 'd' symbol

['little', 'better', 'pretty', 'matter', 'letter', 'committee', 'pattern', 'battle', 'attitude', 'settle', 'bottom', ...]

So I thought it could be done with a for loop like:

for element in list:
     UPDATE table_name
     SET phonetic = REPLACE (phonetic, 't', 'd')
     WHERE vocab = element

would work but I couldn't find any information regarding creating a list on SQLite DB browser. I couldn't find anything online either.

Expected outcome:

vocab   phonetictranscription_bre   phonetictranscription_ame
little           ˈlɪtl                       ˈlɪdəl
settle           ˈsɛtl                       ˈsɛdəl
...


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source