How to specify multiple search columns for wp list table search

Ok i see my WHERE mistake

I made this working solution doesn’t look pretty

$i =0;
        foreach( $searchcol as $col) {
            if($i==0) {
                $sqlterm = 'WHERE';
            } else {
                $sqlterm = 'OR';
            }
            if(!empty($_REQUEST["s"])) {$query .=  ' '.$sqlterm.' '.$col.' LIKE "%'.$search.'%"';}
            $i++;
        }