Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2007-11-18 01:07:41

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

How 2 change custom_field value over all articiles via mysql query?

I’m using dzd_counter_view plugin to show popular articles. It strores article views in custom_2 field (i set so). The aim is to null custom_2 field value over all my articles. I think that it’s work for mysql query but i don’t now how2 :)

I’m using rss_admin_db_manager and i think i can run query from this plugin – please help me to compose the query string.

Thank you!


Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?

Offline

#2 2007-11-18 10:58:45

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: How 2 change custom_field value over all articiles via mysql query?

UPDATE textpattern SET custom_2 = '0'

Offline

Board footer

Powered by FluxBB