Laravel how to check for duplicate records before inserting into Mysql

So I am using .csv files for bank statement records that I want to import into mySQL using Laravel, however I want to validate the records to check for duplications. I have created a "checkrow" field below which is a combination of the fields from the .csv file.

When I run the "BankStatement::create($product); " to update table, I have a row in the mysql table called "checkrow" (which updates from the 'checkrow' field above) which is unique in mysql (does not allow duplicates), however when I run this code it gives a "Integrity constraint violation" which is exactly what its supposed to be doing.
However, I would like it to skip this row in the .csv file and move onto the next to insert to mysql when it identifies a duplicate.


View on Stack Overflow