$wpdb->prepare should merge all arguments to pass to vsprintf
|Reported by:||westi||Owned by:||westi|
Currently you can't do something like this:
$wpdb->prepare("SELECT * FROM $table WHERE `x` = %s AND type IN (%d,%d,%d)", $where, $in_array);
You can do:
$wpdb->prepare("SELECT * FROM $table WHERE type IN (%d,%d,%d)", $in_array);
It would be really good if prepare took all the replacement arguments and built up a single array for you so you had the freedom to pass in arrays and strings for different replacement types.
Inspired by #11100