how to replace some text separated with new lines in mysql ?

[D4rk]

hi

i have some posts which have some text like this

</p>
</div>
</span>

i want to replace them into

</code>
</div>
</span>

any help ?

__________________
Added after 15 Hours 36 minutes:

any reply ?

 

[sohom]

read this TUT:
How to Perform Mass Search and Replace in Wordpress

 

[D4rk]

read this TUT:
How to Perform Mass Search and Replace in Wordpress

and using the

• UPDATE wp_posts SET post_content = REPLACE (
• post_content,
• 'Item to replace here',
• 'Replacement text here');

this will allow me to replace text in new lines ? since the replaced text is in between the quotation marks ?

 

[sohom]

in your case
Item to replace here = </p>
Replacement text here = </code>
within quotation

Note- make a backup of your Database before doing any thing
or test it in a demo Wordpress installation
Since PHPmyAdmin is difficult for new users

 

[D4rk]

in your case
Item to replace here = </p>
Replacement text here = </code>
within quotation

Note- make a backup of your Database before doing any thing
or test it in a demo Wordpress installation
Since PHPmyAdmin is difficult for new users

i cannot replace the </p> with the </code>

since i have other </p> in my posts but in the first lines

i want to delete the last line of some posts (over 200 posts)

and that last line contains some codes which are the same as some wanted codes in the first lines

got it ?

 

[Tango]

You would need to check in phpmyadmin DB, post table to see how the code is stored, from your 1st post it would be

UPDATE wp_posts SET post_content = REPLACE (post_content, '</p>
</div>
</span>', '</code>
</div>
</span>');

 

[D4rk]

thanks a lot

but is there any guide to see how the post looks like in my Database ?

 

[Tango]

There are many ways.

You could browse the post table, click on a post_content box to edit entry, add a space or something then click another entry so that saves, then phpmyadmin will show you the update query, so you will see the exact query.