mysql multiple query based on values

So, I have a following js and php:

JS:

var names = jQuery('#name').val();
data : {'action':'AJAX' , name:names },

PHP:

global $wpdb;
$names      = $_POST['name'];
$name    = explode(',', $names);    
$table     = $wpdb->prefix . 'my_name'; 
$RSS = $wpdb->get_col("SELECT number FROM $table WHERE sub_id = $name");

So, here is the thing, this #name can have multiple values (for example, steve,sean,mike).

I need to do multiple search WHERE = $name based on the number of values that I have.

I thought I would explode each value then use them.

However, that’s as far as I gotten and not sure how to put a necessary condition in the query.

Any help would be much appreciated.

Thanks.