// Count the number of fruit names

$favFruitsCount = count($multipleFavFruits);

// Prepare the right amount of placeholders, in an array

 // For strings, you would use, ‘%s’

$stringPlaceholders = array_fill(0, $favFruitsCount, ‘%s’);

// Put all the placeholders in one string ‘%s, %s, %s, %s, %s,…’

$placeholdersForFavFruits = implode(‘, ‘, $stringPlaceholders);

Now, our query with multiple placeholders would be:

$query = “SELECT color FROM $fruitsTable WHERE fruit IN $placeholdersForFavFruits”;

// get the corresponding colors for the fruits

$mutlipleColors = $wpdb->get_results($wpdb->prepare($query, $multipleFavFruits));