Can MySQL replace multiple characters?

You can chain REPLACE functions: select replace(replace(‘hello world’,’world’,’earth’),’hello’,’hi’) This will print hi earth. You can even use subqueries to replace multiple strings! select replace(london_english,’hello’,’hi’) as warwickshire_english from ( select replace(‘hello world’,’world’,’earth’) as london_english ) sub Or use a JOIN to replace them: select group_concat(newword separator ‘ ‘) from ( select ‘hello’ as oldword union all … Read more