Joomla 3.6 + k2 2.7 hosted on my own linux server.
Since the modification of each item follows a certain pattern, I think I should be able to do it programatically. There are 3 possible ways I can think of:
1) Using phpmyadmin, directly edit the
fulltext field. This is the most straightforward way, but I am not sure if directly editing database is going to cause some potential problem. Besides I am not very familiar with SQL, so I am reluctant to do it this way.
2) Hardcode some PHP file, get connected with the database, read the
fulltext field, do the modification with PHP and put them back to the table. I am more comfortable with PHP, but I've never done such things before.
3) Is there any extension that can accomplish such job?
Which approach would be the best practice?