Wildcard in MySQL query?

[phphelpneeder]

Hi there,

I want to find and replace any instances of a number in any part of my database.

At the moment i'm using

UPDATE table_name SET field_name = REPLACE(field_name, 'wrongnumber', 'rightnumber');

Which is fine for one field in one table. But I want somesort of wildcard so it performs the function on all fields in the db,

any help please?

[run2web]

There is no way to update multiple tables in MySQL.