SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tablename (`vocabulary` TEXT, `phonetic_transcription` TEXT);

INSERT INTO tablename (`vocabulary`, `phonetic_transcription`) VALUES
  ('dream', 'dɹim'),
  ('drain', 'dɹeɪn'),
  ('drink', 'dɹɪŋk'),
  ('adrenaline', 'əˈdɹɛnəlɪn');
UPDATE tablename
SET phonetic_transcription = phonetic_transcription || ' / ' || REPLACE(phonetic_transcription, 'dɹ', 'ʤɹ')
WHERE INSTR(phonetic_transcription, 'dɹ');
SELECT * FROM tablename;


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

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