Quote:
|
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
