SELECT * FROM tablename WHERE UPPER(fieldname) LIKE UPPER('%searchvalue%');

INSERT INTO table1 (field1,field2) SELECT field1,field2 FROM table2 WHERE id='1';
DELETE FROM table1 WHERE id='1';