In the node table, you'll find everything except the actual body. Where can I find this body text? I'm assuming it's being stored as a blob somewhere.
I don't have a running drupal installation here, but I asked myself this very question a couple of weeks ago, and it took time to find the answer.
If I remember correctly, the body of the node is stored in the table that is used to keep the "revisions" of the node. I am not sure what its name is, but it should be something like "node_revision" or "node_revisions."
In Drupal 7 the body has been moved to the field_data_body table.
It's the "node_revisions" table, in Drupal 5.
In Drupal 6, content of the node's body is saved in 'node_revisions' table under 'body' field.
In Drupal 7, content of the node's body is saved in 'field_data_body' table under 'body_value' field. In case content revisions are there then it also saves the data in 'field_revision_body' table under 'body_value' field.
In Drupal 8, content of the node's body is saved in 'node__body' table under 'body_value' field. In case content revisions are there then it also saves the data in 'node_revision__body' table under 'body_value' field.
Your content types body content is saved in
This is the SQL you would use (MySQL client):
SELECT node.nid,node.vid,type,node.title, body FROM node join node_revisions ON node.nid = node_revisions.nid WHERE node.title = 'some title';
So yes, the answer is the "node_revisions" table in Drupal 6.
In Drupal 7, the node body is found in field_data_body and field_revision_body. New fields added using CCK (which is added to core in Drupal 7) are found in field_config and field_config_instance. In Drupal6, the node body is stored at node_revisions and fields created are saved at content_node_field and content_node_field_instance.
I have created few new content types, and for them, the body or the description goes to column field_description_value of table
type_name is the new content type's name.
In Drupal 7 its in field_revision_body .. if you describe that table you will see theres a col for Body summary and its a longtext type.