mysql - SQL query: Copy all rows with Store_ID = 1 -

i have table review_store 2 columns: review_id , store_id if had replace 1 2, this:

update review_store  set store_id = '2'  store_id = '1' 

how copy/duplicate every row in store_id = 1 store_id = 2 ?

i assume mean create new records in same table. use insert select

insert review_store select review_id, '2' store_id review_store store_id = '1'