How to batch update articles viewing option via php admin

[fangweile]

Hello there,

I have created more than 250 articles and I want to change the viewing option for all articles in category id 4.
I want to display only the following options.

Code Select Expand

title,linktree,top,cblock,rblock,tblock,lblock,lbblock,category,inherit,social,nofrontsetting

I have tried to run this sql query but it failed

Code Select Expand

UPDATE smf_tp_articles SET OPTION = 'title,linktree,top,cblock,rblock,tblock,lblock,lbblock,category,inherit,social,nofrontsetting' WHERE category = 4

Thanks in advance for any help

[fangweile]

Alright, It is working fine now. The query actually worked I just didn't notice it.  My bad