php - How to update this query with 2 data arrays for WHERE condition -

hi have 2 data arrays ,

$lob_array = array(200,201,300); $preference_array = array(500,501,502,503,504,505); 

i have table rating

it has fields

rating_id | lob_id | preference_id | average_rating | is_delete 

i want update is_delete column values according data array .

i want compare each lob value $preference_array

update  rating set is_delete = 1    (lob_id=$lob_array[0] , preference_id in (".implode(',',$preference_array).")) ) or  (lob_id=$lob_array[1] , preference_id in (".implode(',',$preference_array).")) ) or  (lob_id=$lob_array[0] , preference_id in (".implode(',',$preference_array).")) ) 

how can , please , because don't know number of elements in $lob_array in advance.

would work?

update  rating set is_delete = 1    (lob_id in (".implode(',',$lob array).") , preference_id in (".implode(',',$preference_array)."));