sql command help

[Mr.Mirchi]

Hi.... in my wordpress site ,, for about 200 posts i had used for bold,since was using the bbcode plugins..... no i want to replace the & with <strong> and with </strong> .....

how can i do this with phpmyadmin sql query command ?


please help

Mr.Mirchi Reviewed by Mr.Mirchi on 25th Dec 2011. sql command help Hi.... in my wordpress site ,, for about 200 posts i had used for bold,since was using the bbcode plugins..... no i want to replace the & with <strong> and with </strong> ..... how can i do this with phpmyadmin sql query command ? please help Rating: 5

[Allan]

If U can List the Table and its attributes , I can help u with the command As I am not aware with the structure of VB..

[Mr.Mirchi]

^its a wordpress site... if u can give a genral syntax like wp_ being as table name.. it would be helpful bcz there are 5-6 blogs i have like that

[AlternativeWeb]

Like Allen said, without the tables, its hard to know what exactly you need, but I assume you played around with SQL enough to know what to replace it with.

UPDATE subject SET body = REPLACE ( body , '<strong>', '</strong>' )

The following below might be the only thing you need to change

subject
body
<strong>
</strong>