Thu, 01 Apr 2004 00:06:49 +0000

Hi All,

I'm new to the board, new to MySQL, and have become the company 'webmaster' by default...

With that said, my situation is similar to Diana's, except that my column doesn't contain just one word. What I need to do is change a single word "cover" to "covers" in ever instance throughout the `description` field.

From: "blah blah blah cover blah blah"
To: "blah blah blah blah covers blah blah"

I have a feeling this is going to be WAY over my head..but thanks in advance for any help.

-john

diana — Thu, 25 Dec 2003 04:36:34 +0000

Thanks Greg...I certainly appreciate all your help. Wish you Merry Christmas and Happy New Year. Happy holidays...

Rgds
Diana

Greg K — Thu, 25 Dec 2003 02:50:45 +0000

That should do it for you, then don't forget to run a second query for chaning the WITHOUT to NO.

After you execute the query, you can check mysql_affected_rows($result) to see how many rows it updated.

-Greg

diana — Wed, 24 Dec 2003 13:56:01 +0000

Hi Mark,

Thanks for such quick reply.It looks so simple:)...will it update all the 12,000 rows?..say I have the query build up like...
$result=mysql_query("UPDATE users SET intro='YES' where intro='with', $link);

Now does the above query will update all the rows where 'intro' is found to be having a value 'with' and change that value to 'YES'....?

Well I am getting it....I seems to be such a novice:)...long way to go....thanks Mark...Merry Cristmas to you and your family..

regards
Diana

mairving — Wed, 24 Dec 2003 13:11:58 +0000

Diana, welcome to WMF and Merry Christmas to you also. If you want to update records in MySQL assuming that your column contains values like 'with' or 'without' and not 'with other stuff' or without other stuff', in other words only a single word in those columns, then it is pretty easy to do with a simple query. Just do:
UPDATE tablename set column_name='Yes' where column_name='With';

Now this problem could have been solved from the beginning if the column type was either a single character (Y and N or 1 and 2). This way you can save a little database space and avoid some redundancy.