In Craft, is it possible to map one field containing string value to another?
I have a bunch of image assets that has a title field and
altTag fields. I've entered data into the alt tag field, but now I would like to copy that data for each asset into the
title field for that same asset.
Doing this manually for each asset would take forever, but it sounds like something that could be done with mysql queries.
I poked around the database to see where the
title fields or the
altTag fields are stored. The
altTag field is in the
craft_fields table, and I can see all my assets in the
craft_assetfiles table. But
title is not one of the columns in this table, I do see the
filename column. But I think my knowledge of the structure of craft tables are lacking to find where the values for the
altTag fields are stored or how to copy the value of each alt tag into the corresponding title field for the asset.