mysql query

[nullified]

this isn't working as I would like. I'm trying to combine several queries into one:

$db->query_write("UPDATE " . TABLE_PREFIX . "usergroup SET bannercanuse = '0' WHERE usergroupid = '1' LIMIT 1");
$db->query_write("UPDATE " . TABLE_PREFIX . "usergroup SET bannercanuse = '0' WHERE usergroupid = '3' LIMIT 1");
$db->query_write("UPDATE " . TABLE_PREFIX . "usergroup SET bannercanuse = '0' WHERE usergroupid = '4' LIMIT 1");
$db->query_write("UPDATE " . TABLE_PREFIX . "usergroup SET bannercanuse = '0' WHERE usergroupid = '8' LIMIT 1"); 

[mlx]

$db->query_write("UPDATE " . TABLE_PREFIX . "usergroup SET bannercanuse = '0' WHERE usergroupid IN (1, 3, 4, 8)");