Is there possibility to update MySql table if ids in array like $ids=['key1'=>'value1','key2'=>'value']
. $ids
keys are ids in MySql table!
I can loop through $ids
and do something like
foreach($ids as $key=>$value)
do_query(UPDATE table SET column=$value WHERE $id=$key);
But want something to do all updates in one query,not to do count($ids)
queries!