Is there any faster query way of rewriting these queries or by combining them?
update products
set shop = '1'
where shop LIKE '%demo%'
update products
set shop = '2'
where shop LIKE '%car%'
update products
set shop = '3'
where shop LIKE '%art%'