Lets say you have a bunch of nodes that have all been created with the body field set to use the 'Filtered HTML' format, and you then decide that you want them to all use the 'Full HTML' format.
You could open each item and manually change the format, or you could run a SQL query like the below (remember to also update the 'revision' field too):
UPDATE field_data_body SET field_news_stand_first_format='full_html'; UPDATE field_revision_body SET field_news_stand_first_format='full_html';
Here are the values associated with the default text formats:
- Full html = full_html
- Filtered html = filtered_html
- PHP code = php_code
- Plain text = plain_text
- Display Suite code = ds_code
Avid Drupal site builder & user for +10 years.