'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 |
|---|
