MySql statement needed

[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.