MySQL Forums
Forum List  »  Newbie

Re: Query Help
Posted by: Trevor Wilcox
Date: January 21, 2019 10:16PM

On a related note, in the same wp_usermeta table, there is another meta_key called wp_s2member_custom_fields. The plugin that stores the data in this field does so in a PHP produced serialized array, such as follows:

a:6:{s:6:"gender";s:1:"M";s:3:"dob";s:8:"1/5/2005";s:10:"sailprefix";s:3:"HKG";s:10:"sailnumber";s:3:"520";s:4:"club";s:3:"ABC";s:9:"hkodalaws";s:1:"Y";}


This is a nightmare, but until such time as the plugin handles these values differently, it is what it is.

Is there a way I can extract this data and display them in their own columns, alongside the first_name and last_name columns from my original enquiry above?

Many many many thanks

Options: ReplyQuote


Subject
Written By
Posted
January 21, 2019 10:08PM
Re: Query Help
January 21, 2019 10:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.