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

Duplicate Thread. Closing.

See: http://www.s2member.com/forums/topic/how-to-get-array-of-user-ids-by-custom-field/