Category "substr"

SQLite string search in rows then insert string into new rows with values of the same row last column

I want to provide a query to my database that will search if a string exists in Column2(site_id) then put that string in a new table with the value of its befor