If you need to change input format for a node on your Drupal-based site, you can do this manually or via SQL-request. In this article, I will tell about the SQL-request. I suggest that you can change input format manually for every node.

Important! Make a backup copy of a database before implementing the instructions.

If you need to change format for all site nodes, you can use the following request:

UPDATE `node_revisions` SET `format` = ‘2’;

Input format numbers:

1. Filtered HTML
2. Full HTML
3. PHP code

If you need to change format just for some nodes, the request will look like:

UPDATE `node_revisions` SET `format` = ‘2’ WHERE `nid` = ‘332’;

Specify nodes you wish to apply changes for in WHERE condition.

Good luck!