WHERE NOT EXISTS in MySQL : Inserting into table if one data of a field name exist?

Question

My database structure

id | name | contact | location

 1 | ABC  | 012444452 | Koh

How to not insert other data into database if contact number is the same(exist) and skip.

my query

$query = mysqli_query($con, "INSERT INTO test(name, contact, location) VALUES ('$name', '$contact', '$location')");

Thanks.

Possible duplicate, and if not, very relevant: http://stackoverflow.com/questions/18114458/fastest-way-to-determine-if-record-exists — Luke Joshua Park, Nov 19 '15 at 04:32
before inserting data just check whether it is already in db or not — Pathik Vejani, Nov 19 '15 at 04:40
What fred said, if it has to be unique then put a unique constraint on it. — NSNoob, Nov 19 '15 at 04:57

Subin Chalil · Accepted Answer · 2015-11-19T04:41:05.483

3

You can use WHERE NOT EXISTS with INSERT.

"INSERT INTO test(name, contact, location)
 VALUES ('$name', '$contact', '$location') 
WHERE NOT EXISTS (SELECT * FROM test WHERE `name`= '$name')".

Hope this helps.

edited Nov 19 '15 at 04:41

answered Nov 19 '15 at 04:34

Subin Chalil

@Subic C Poonamgode i dont know if you still can help, but should this work with php and mysqli using mysql database? – Ingus Jun 14 '17 at 14:43

1 Answers1