I wanted to replace some strings in queries' title and content and run the following SQL queries in phpMyAdmin:
update qa_posts set title = replace(title, 'xxx', 'yyy');
update qa_posts set content = replace(title, 'xxx"', 'yyy');
After that the error appeared when I tried to open a question with replaced strings:
Notice: Undefined index: content in /path/to/qa-include/qa-theme-base.php on line 1914
I tried to repair tables but the MySQL engine is InnoDB and it doesn't support the repair feature through phpMyAdmin, so I restored the database.
The question is how to replace strings in title and content properly?