I have this database of about 60k+ articles which contains html tags within the article body field. I aint much of a php programmer, so i was wondering if any of you guys can help me out a bit with a short script which would search all records and convert the html tags within the article body field to html entities.
MySQL might have a function to do this direct, without using PHP. You would have to ask in the database forum.
PHP could do it using str_replace(). You would just have to tell php what to look for, and what to replace it with. You could also look into the htmlentities() function.
Be certain you do a full backup of your database before you try anything.
