XF 2.3 How to remove descriptions of all nodes (by SQL)?

[securedme]

I would like to empty all descriptions of all nodes.

 

[AndyB]

Here you go:

UPDATE xf_node SET description = ''

 

[Rene_V]

A word of advice if I may, make first a backup of the node table before running the query. Personally I always make a backup of the entire database before I edit things in there manually. If things go south I always have the backup to fall back on.