How to get array of user-id's by custom field

Hello,

I want to creat a list of users on my website. I want to get the user id’s in an array by user custom registration fields.
I have a checkbox input on the registration form.
The uniek-id is model_category.
The posible values are:
Fashion
Real
Special
Acteurs

I want to use something like this to get the Id’s of a groep of users.

$UserIDs = $wpdb->get_col( $wpdb->prepare(“SELECT $wpdb->users.ID FROM $wpdb->users XXXX”)

XXXX need to do this: WHERE model_category contains “Fashion”

But I can’t figure out how to do this. I;m not that good with SQL Querys.

I have also tryed this (but it didn’t work):
$wpdb->get_col (“SELECT user_id as ID FROM ” . $wpdb->usermeta . ” WHERE meta_key = ‘” . $wpdb->prefix . “s2member_custom_fields’ AND meta_value REGEXP ‘.*”model_category”;s:[0-9]+:”‘Fashion'”.*'”);

Can you please help me out?

Thank you.

Kees Veerman

Thank you for your inquiry.

This is something’s a little out of scope of support. We don’t deal with custom code. I can tell you that I would recommend just pulling in all of the User’s custom fields (or a section of the Users) and pulling in an array into PHP to deal with. It’ll be less of a hassle with using Regex, and would probably be less stressing on your site.

See: s2Member® » Support Policy » Outside Scope