Database Custom Fields
Development and Programming
I’m looking to write some SQL queries on the ExpressionEngine database and have a few questions about the column names. If I look at my exp_channel_data table I see a bunch of columns that are incremented field_id_1….field_id_150, etc, but do not have the actual name of the field that was set up in the control panel.
All my entries have the same basic information, which would be one of three values, so it makes it impossible to tell which column belongs to which custom field. Am I missing something?
Is there an easy way to figure out the name of the actual column instead of this arbitrary column name?
ac.
Hi Anthony,
That information is stored in a separate table in the database (in the format you are looking for). We cannot really guide you in how to make direct changes to your ExpressionEngine Database and we caution against doing so unless you are extremely confident in your abilities.
I’m going to migrate this to the Development and Programming area and let the Community there offer their guidance and insight.
Cheers,
In the exp_channel_data column names the integer at the end of the column name corresponds to the field_id in the exp_channel_fields table which also contains the fields field name.