Page 1 of 1

Need a simple MySQL query...

Posted: Wed Mar 31, 2010 6:26 am
by kevinkhan
I have two tables in my database one called Category and the other called CategoryParent

Is there anyway of replacing all the words in the table columns with another word..

We say from London to Mancester?

Does anybody know?

Re: Need a simple MySQL query...

Posted: Wed Mar 31, 2010 8:32 am
by mikosiko
without knowing your table structure seems that what you want to do is a simple UPDATE ... like

Code: Select all

UPDATE nameoftable
SET nameoffield = "Mancester"
WHERE nameoffield = "London"