Problem with mysql query to replace a string
- by alex
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.