UPDATE `phpbb_topics` SET `topic_views` = '145' WHERE `topic_id` =1
This is the code you get when manually editing a single post's view count in phpMyAdmin, and the topic ID is 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
UPDATE `phpbb_topics` SET `topic_views` = '145' WHERE `topic_id` >=1
Would set the topic views of all posts to 145.
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.