I want to insert rows into MySQL for three columns, but ignore the insert if ALL THREE COLUMNS are duplicates
Here's my current sql statement in PHP (example):
$sql = "INSERT INTO test
(id_number, user_id, username)
This works fine, however if there was already an id_number of '1234' in the database, it will now have two such entries.
I would like 1234 to be ignored, but ONLY if:
1234 is already present in a row
user id 10 is already present in same row
username john is already present in same row
Is this possible in one SQL statement?