Replace / update a Typo

[Topshed]

mySQL ver: 5.1.30

PHP  ver: 5.2.8

 

I have a typo in over 400 records and I want to fix it in phpmyadmin

The field is tinytext and the string I am trying to fix is 91 chars long

I am trying to fix a small section of the string

 

My efforts are a dismal failure  ie:

 

UPDATE lms  SET cut =  'Co.T'    WHERE cut = 'Co.,T'

 

Your help would be most welcome

 

Topshed

[requinix]

Try REPLACE.

[Topshed]

Thanks for the reply, but no Joy, assuming that you ment

REPLACE lms SET cut =  'Co.T'    WHERE cut = 'Co.,T'

 

Topshed

[requinix]

What I meant was for you to click the link and read what it pointed to. That's why I put it there.

[Topshed]

Thanks for the clarification but unfortunatly 28 pages to sort thru was not the quick fix I was looking for,

rather just a correction to my inept code

Regards..

 

[requinix]

  Quote

28 pages to sort thru

Well that's funny. Because when I click that link I posted I arrive immediately at

  Quote

REPLACE(str,from_str,to_str)

 

Returns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str.

 

mysql> SELECT REPLACE('www.mysql.com', 'w', 'Ww');
        -> 'WwWwWw.mysql.com'

This function is multi-byte safe.

Maybe your Internet isn't the same as my Internet...