MySql statement needed

[porno0net]

Originally Posted by CelticTiger

Can someone tell me if there is a MySql statement that will do a search and replace on a database? Or any alternative maybe?

UPDATE links SET niche='Amateur' WHERE niche='Amaateur';

UPDATE links SET niche='Hairy',status='Active' WHERE submitter='xxxx' AND email like 'some_dude%';

I hope this helps

[CelticTiger]

Originally Posted by porno0net

UPDATE links SET niche='Amateur' WHERE niche='Amaateur';

UPDATE links SET niche='Hairy',status='Active' WHERE submitter='xxxx' AND email like 'some_dude%';

I hope this helps

Thanks for your help - I'm a dumbass when it comes to this stuff so can you clarify it a little for me? Basically what I want to do is remove all instances of any exclamation marks(!) within any link descriptions.