Replacing words containing an apostrophe

I am also having the same problem.
I tried using plug-ins to find and replace but it won’t work properly if your text has an apostrophe.

For example:
UPDATE wp_posts SET post_content = REPLACE(post_content, ‘[show_to level=”VIP”]’, ‘[s2lf current_user_is(s2member_level1)]’);

If I use this command the command above it gives a different result.

Please help.

Please try this version: Test Version of Search & Replace. If you downloaded this earlier, please download it again as I have changed it to address this bug. Please let me know how it works for you.

Ok, the plugin author (Frank) will be away for a month, so I tried to fork the plugin, but there’s 116 plugins waiting review.

You can download the new plugin directly from my site for now. Please let me know if it works for you.

The fixes from RonG are now inside the new version. THANKS to RonG

Same problem with the apostophies here I’m afraid. And unfortunately the new version (2.7.0) in the links above doesn’t work for me. I tested both – just to be sure (under both WordPress V4 and the previous version).

Just to clarify how the problem looks at my end; If a search term contains an apostrophe and you carry out a search & replace it tells you that its found and replaced all instances. So initially all looks fine. But actually it either does nothing or adds a backslash in front of the apostophies.

Real shame, as this has been a great plug-in up till now. So I’ll have to find a replacement, but will look out for a fixed version in the future.

@brack29. Do you have also a example for a string, that you search. Please also test the new version The older version have a difference between the s/r inside the database and the result, that you see inside the tools page of the plugin. Maybe your problem is topic of this error.