Hi,
Searching won’t be possible for sure, as the information is serialized. That is not possible to search with the MySQL database.
I understand the information, but it won’t help in your case. There must be some kind of function or a class function that can retrieve the option values based on the custom field name/value, something like:
[html]get_option_display_value($user_id, ‘peepso_user_field_3197’, ‘option_3197_2’); // returns ‘Afghanistan'[/html]
Or simply just something that translates the option into the value, like:
[php]get_display_value(‘option_3197_2’);[/php]
If any similar function/class method exists, then let me know.