Friday, January 11, 2002, 12:26:00 PM, you wrote:

> Hi there,

> I wonder if anyone can help?
> How would I go through a whole table changing the values:

> StuartD to stuartd

UPDATE users SET username = 'stuartd' WHERE username = 'StuartD';

-- 
Pål Sollie - [EMAIL PROTECTED]

Change is good most of the time,
but it is bad when it sucks.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to