Need a simple MySQL query...

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
kevinkhan
Forum Newbie
Posts: 9
Joined: Wed Jan 06, 2010 8:08 am

Need a simple MySQL query...

Post 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?
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: Need a simple MySQL query...

Post 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"
Post Reply