Как можно сократить SQL-запрос?

Рейтинг: 1Ответов: 1Опубликовано: 13.03.2015

Такой вот страшненький он.

$db->query("UPDATE `list` 
               SET `checked` = 1 
             WHERE `id` = $getList1[0] 
               AND `id` = $getList1[1] 
               AND `id` = $getList1[2] 
               AND `id` = $getList1[3] 
               AND `id` = $getList1[4] 
               AND `id` = $getList1[5] 
               AND `id` = $getList1[6] 
               AND `id` = $getList1[7] 
               AND `id` = $getList1[8] 
               AND `id` = $getList1[9] 
               AND `id` = $getList1[10]");

Ответы

▲ 2Принят
$db->query("UPDATE `list` SET `checked` = 1 WHERE `id` IN ('". implode("','", $getList1) ."')");