This is the code you get when manually editing a single post's view count in phpMyAdmin, and the topic ID is 1.
UPDATE `phpbb_topics` SET `topic_views` = '145' WHERE `topic_id` =1
What I am needing to do, is to edit all posts at once, and instead of setting the views of every topic to 145, I want to add 145 to every thread's number of topic views. Make sense?
I know that
Would set the topic views of all posts to 145.
UPDATE `phpbb_topics` SET `topic_views` = '145' WHERE `topic_id` >=1
SO my question, is there (and if so, what is) the MySQL command to increase the number of topic views by a number I specify rather than to set the number of topic views on all threads to a specific number.