mysql replace

select replace(introtext,'.MP3','') from j25_content where  introtext like '%.MP3%';

update [TABLE] set [EMAIL] = replace([EMAIL], SUBSTRING_INDEX([EMAIL], '@', -1), '@XYZ.COM');

update j25_content set introtext=replace(introtext,'.mp3','') where  introtext like '%.mp3%';

 update j25_content set introtext=replace(introtext,'mgmediabot2','mp3') where  introtext like '%mgmediabot2%';