MySQL Query needed

[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?

[trq]

Your question is about as clear as mud.

 

UPDATE tbl SET fld = 'Mancester' WHERE fld = 'London';

[kevinkhan]

Your question is about as clear as mud.

 

UPDATE tbl SET fld = 'Mancester' WHERE fld = 'London';

 

Thanks but the fields contatins paragraphs like

Flats and Apartments in Dublin

and another field

Dating in Dublin

 

and i want it to become

Flats and Apartments in Limerick

and

Dating in Limerick

 

Is this possible??

 

 

[trq]

Of course its possible.

 

UPDATE tbl SET fld = REPLACE(fld, 'Dublin', 'Limerick');

[kevinkhan]

Of course its possible.

 

UPDATE tbl SET fld = REPLACE(fld, 'Dublin', 'Limerick');

 

Wow. thats cool man..

 

thanks