Help with db_delete using both LIKE and IN.. I'm trying to delete many rows whilst having a wildcard
You can't combine LIKE and IN in the way you are attempting.

You will need a run a different query for each UID. 

E.g.

$cid_base_pattern = db_like($module) . ':' . db_like($block) . ':' . db_like($theme) . ':%:u.';

foreach ($uids as $uid) {
    db_delete('cache_block')
      -&gt;condition('cid', $cid_base_pattern . $uid, 'LIKE')
      -&gt;execute();
}