Updating all cells in a database

[nadz]

im trying to add an option which allows the user to change their username. Usernames appear in my database in a number of tables under a several fields. i thought rather than using UPDATE queries for each field there might be a query that allows me to update all cells in the db where for example the value is "user124".

 

any help would be appreciated

[nadz]

i found this article but im not entirely sure how to use it in php:

 

http://vyaskn.tripod.com/sql_server_search_and_replace.htm

[fenway]

the username should only appear once in the entire db, store the uid instead.

[teng84]

i guess the tread starter problem is the normalization instead of using the id as the foreign key he use the user name whic is incorrect so maybe he want to replace the record in db tables having that user name

 

if u use id as the foreign key it will always be one table to be updated