Skip current row import when requirements not met in collection method

[dickygiancini]

I was trying to do import on clients file and since i need to validate if it exists in databse, i use this method

public function collection(Collection $rows)
{
        foreach ($rows as $row) 
        {
            $species = DB::table('species')->where('name', 'like', "%$row[0]%")->first();
            
            if(!$species)
            {
                 // i got stuck here
            }
        }
}

i need to validate if it doesn't exists, it will skip that row and continue checking on the next row. How do i do that?

[patrickbrouwers]

$species = DB::table('species')->where('name', 'like', '%$row[0]%')->first();

^ This does a like on the string value $row[0]. Make sure you pass the variable '%' . $row[0] . '%'

[dickygiancini]

whoops, i missed type it. but yes it should be like it. Any idea how i can skip the current row if the query is not met?

[patrickbrouwers]

'break;' I guess