MySQL table for for birthday

  • January 8, 2021 11:33 AM EST

    The member's profile include the birthday. Many of the field are contained in engine4_user table. I have explored other engine4_user_fields_*** but can't find the date of birth.

    Please help me with this. What is the name of the table with DOB?

    I noticed the year can be hidden in 5.4.0. Thanks for this change I requested. I will test it in a little while.

    • Moderator
    • 6650 posts
    January 8, 2021 6:22 PM EST

    Well there are the values stored in the engine_user_fields_values . It would correspond to the user number and corresponding field id. On my site, the birthday is id 6. The field id can be found in the engine_user_fields_meta. 

  • January 8, 2021 9:55 PM EST

    Thanks Donna for the quick answer. I am not a database expert but I have been able to export the user and the values table to Excel. I then used Excel's Vlookup function to combined the birthdate (or other values) in a single spreadsheet I needed for something else.