I would like to modify the following code to do a "batch" insert and using a where clause with values provided in the array..
Code is taken from the provided link : MySQL: Insert record if not exists in table
INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' );