0

I've read how to perform a find-replace in mysql,

UPDATE `table_name`
 SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

but i'm stuck with a particular string (my unwanted_text), that is

<span style="font-size: 12pt;">

In order to prevent any unwanted result, i'm testing my query just finding the previous string.

I've tried to escape double quotes with \" and even blank spaces with \ but it doesn't work.

<span\ style=\"font-size:\ 12pt;\">

How should be unwanted_text?

Community
  • 1
  • 1
Zikyi
  • 1
  • Did you quote the whole text? `''` – Ethan F. Apr 28 '16 at 20:10
  • Are the values *exactly* the same? Do you want to remove all tags, or only this specific one? What about the corresponding closing tag? Is that not in your column values? – trincot Apr 28 '16 at 20:14
  • Yes to both, but finally found the issue. Thank you, i'm going to reply with the answer... – Zikyi Apr 28 '16 at 20:26

1 Answers1

0

Solved. It was Phpmyadmin through its search function converting: it was adding another \.

Through direct sql input everything works fine.

Zikyi
  • 1