delete from oxartextends where OXID in ("test0","test1","test2","test3");

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test0','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test0','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test0','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test0','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test1','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test1','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test1','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test1','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test2','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test2','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test2','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test2','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';

insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_3) VALUES ('test3','insert 3') ON DUPLICATE KEY update oxartextends.OXLONGDESC_3 = 'update 3';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC)   VALUES ('test3','insert 0') ON DUPLICATE KEY update oxartextends.OXLONGDESC   = 'update 0';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_1) VALUES ('test3','insert 1') ON DUPLICATE KEY update oxartextends.OXLONGDESC_1 = 'update 1';
insert into oxartextends (oxartextends.OXID, oxartextends.OXLONGDESC_2) VALUES ('test3','insert 2') ON DUPLICATE KEY update oxartextends.OXLONGDESC_2 = 'update 2';

select OXID,OXLONGDESC,OXLONGDESC_1,OXLONGDESC_2,OXLONGDESC_3 from oxartextends where OXID in ("test0","test1","test2","test3");