I am trying to searh and replace for certain text within my database but have a small problem.
The text I need to replace is over two lines and I have tried using the HTML chracter entites and a few other tricks but nothing seems to work.
Unfortunately I don't think I am able to perform two seperate queries.
Here is the query text I am using:
UPDATE wp_posts SET post_content=REPLACE(post_content, '<ul>
As you can see there is a line break after the first
Does anybody have any suggestions?