Query with Special Characters

[mathceleb]

I'm trying to do a replace and I get this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\[field_author-nid\]) WHERE display_options LIKE '<a href=\"http://www.test.' at line 1

I tried double backslash with the brackets as well.

update views_display set display_options = replace(display_options, '<a href=\"http://www.test.com/author/\[field_author-nid\]\">\[field_author\\</a>', \[field_author-nid\]) WHERE display_options LIKE '<a href=\"http://www.test.com/author/[field_author-nid]\">\[field_author\]</a>'

[mathceleb]

Oh boy, long day. I got it to work:

PHP Code:

update views_display set display_options = replace(display_options, '<a href="http://www.test.com/author/[field_author-nid]">[field_author]</a>', '[field_author-nid]') WHERE display_options LIKE '%<a href="http://www.test.com/author/[field_author-nid]">[field_author]</a>%'