Use the UPDATE. I assume you mean by "database" here you mean the database table named "members"... if so, try the following query.
UPDATE members SET user_name = 'john_doe' WHERE user_name = 'John Doe';
-- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Caroline Jen wrote:
Hi, I am not a database person. I have a database called "members". One of the fields in this database is "user_name". There are a number of records in this database. Under the field user_name, I would like to make some changes manually; for example, I want to change
John Doe
to
john_doe
Is it possible to do it? How do I do it? Thank you very much in advance.
__________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]