views:

49

answers:

0

I've used mysql's update replace function before, but even though I think I'm following the same syntax, I can't get this to work.

Here's what I'm trying to do:

UPDATE contained_widgets 
   SET preference_values = REPLACE(preference_values, '<li><a_href="/enewsletter"><span class="not-tc">eNewsletter</span></a></li>', '<li><a_href="/enewsletter"><span class="not-tc">eNewsletter</span></a></li> <li> <a_href="/projects"><span class="not-tc">Projects</span></a></li>');


Query OK, 0 rows affected (0.00 sec)
Rows matched: 77  Changed: 0  Warnings: 0

I don't see what I'm missing.

Any help is appreciated.

I edited "a " to "a_" because the site thinks I'm posting spam links otherwise.