mysql update修改多条数据

$display_order=array(23687=>'23687ff',23684=>'23684ff');
$city=array(23687=>'23687ffxx',23684=>'23684ffxx'); 	  	 
	 $ids =implode(',', array_keys($display_order));
	 $sql= "UPDATE table SET name= CASE id";//name 某列 
	 foreach ($display_order as $id => $ordinal) {
	     $sql .= sprintf(" WHEN %d THEN '%s' ", $id, $ordinal);// 拼接SQL语句 
	 }
	 $sql .="END,title = CASE id ";
	 foreach ($city as $cityId => $cityVal) {	 
	     $sql .= sprintf(" WHEN %d THEN '%s' ", $cityId, $cityVal);// 拼接SQL语句 
	 }
	 $sql .= "END WHERE id IN ($ids)";

https://blog.csdn.net/guoshenglong11/article/details/38543005?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522161764082716780265469957%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=161764082716780265469957&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_v2~rank_v29-1-38543005.pc_search_result_cache&utm_term=php+mysql%E6%9B%B4%E6%94%B9%E5%A4%9A%E6%9D%A1%E8%AF%AD%E5%8F%A5