I’m trying to figure out how to update a specific “meta_value” (for “field_id = 179″ in the “wp_frm_item_metas table”) for each form entry submitted by a specific user (ie. item_id). The kicker is that I need to get the proper user “item_id” in that table based on matching another “meta_value” value for (field_id = 184) (ie. an email address) …. then knowing that “item_id” I’ll need to update the meta_value for field_id = 179.
To summarize, I need to find the proper “item_id” based on matching the meta_value for field_id = 184 (ie. email address). Then knowing that “item_id” I’ll then be able to find the meta_value for field_id = 179 – and update it with the new value.
I don’t know SQL. But this seems to be the logic (based on me looking at the mySQL tables).
Can you help me create the SQL Update statement.
P.S. The larger problem is updating the data from a CSV – but I figure first step first.