p a s s i o n + r e a s o n

For my future reference, searching and replacing some text in MySQL, via SQL.

Info from an article at The Media Tank.

UPDATE mt_entry 
	SET entry_text = REPLACE (entry_text, 'classlink', 'class') 
	WHERE entry_text LIKE '%classlink%' 
	AND entry_id="252";

Dunno why MySQL online manual gives a very basic example which is actually quite non-intuitive for figuring out solutions for "real-life" situations.