How to make a SQL query on an array?

Question

SQL

there is an array

array(8) {
  [0]=>
  string(1) "1"
  [1]=>
  string(2) "10"
  [2]=>
  string(2) "11"
  [3]=>
  string(2) "12"
  [4]=>
  string(2) "13"
  [5]=>
  string(6) "122201"
  [6]=>
  string(6) "122202"
  [7]=>
  string(6) "122277"
}

Let's say it is passed in a variable $branches
This is a unique ID of each record in the `test` table in which you need to change let's say `name`
how to do this with a single SQL query

Answer 1

All dialects have an IN operator

$values = join("," , $branches)
$sql = "UPDATE `table` SET `name`='Test' WHERE `id` IN ($values)"