'How to write the exact text next to the text and replace certain letters in it? SQLite

I am creating a phonetic dictionary for American English. Here are some examples:

vocabulary      phonetic_transcription
dream           dɹim
drain           dɹeɪn
drink           dɹɪŋk
adrenaline      əˈdɹɛnəlɪn

If dɹ is in the phonetic_transcription, I want to write an alternative to it replacing 'd' with 'ʤ'. The expected outcome is:

vocabulary      phonetic_transcription
dream           dɹim / ʤɹim
drain           dɹeɪn / ʤɹeɪn
drink           dɹɪŋk / ʤɹɪŋk
adrenaline      əˈdɹɛnəlɪn / əˈʤɹɛnəlɪn

I know how to change a certain element with another with replace function but I have no idea how to do it like above.

sqlitereplacesql-updatedb-browser-sqlite


Sources

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

Source: Stack Overflow

Solution Source

Related Questions

MySQL - How do I enter NULL?

MySQL - How do I enter NULL?

MySQL - How do I enter NULL?

mysql update query throwing syntax error

UPDATE Query without WHERE Clause

Why is my SQL UPDATE syntax giving 'ambiguous column name'?

How to update record with the same data of existing record

How to execute multiple update queries using jooq execute or batch execute without code generation?

SQLAlchemy update multiple rows in one transaction

Remove duplicate entries from string array column of postgres

SQL query - How to increase the salary of employees, without exceeding a certain salary limit

PostgreSQL duplicate key value violates unique constraint while using on conflict do nothing on insert

Using 'on conflict' with a unique constraint on a table partitioned by date

Using 'on conflict' with a unique constraint on a table partitioned by date

SQLite impute missing values by mean for every group