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?
Need a simple MySQL query...
Moderator: General Moderators
Re: Need a simple MySQL query...
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"