Use php to find and replace in entire mysql db?

[lordvader]

I know you can do a query to find and replace all instance of let's say $haystack, $needle, with:

 

UPDATE tablename SET tablefield = replace(tablefield,$haystack,$needle);

 

but that only works for a specific table and a specific field within the table.

 

What do I change so I can search and replace throught the entire database?

 

Thanks

 

[marcus]

UPDATE `tablename` SET `haystack`='$needle' WHERE `haystack` LIKE '%$haystack%'

 

confusing question.

 

replace what with what