I've seen another post about this exact thing but it's 1-1/2 years old so I thought I'd make my own...besides, the other post did not help me. What I am trying to do is pretty straight-forward.
To be on the safe side, I tried a simple UPDATE statement on a different table, which was successful. So, here's my problem:
mysql> UPDATE bugs_fulltext SET short_desc = REPLACE(short_desc,'I don\'t know why my previous comment means.', 'I don\'t know what my previous comment means.') WHERE bug_id=452; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0
I'm not using wildcards nor am I using a LIKE statement. I am telling it which record to update. Why isn't my text changed?