I need to replace some certain text in MySQL database engine table data because there are some changes in company name, postcode, URL and some spelling mistake. So far so good, except that the MySQL database contains all the post data, which includes hundreds if not thousands of instances of the [font] tag. Since it's been disabled, it no longer gets parsed, and no it's being printed to the screen, making posts that include it almost illegible.So do any of you guys make me know how to find and replace text in MySQL database using SQL ? Please help. Its very urgent.
Bookmarks