In my Laravel application, I need to check if there is a specific record in 20 columns in a table. I have searched for this answer but only found a way to check if it exists in a specific column but I need to check all columns and I was wondering if there is a way to do this without a loop, For example:
DB::table('cart')->where($fileId->id)->exists();
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
Assume
$field->idis the search term. You can try//use Illuminate\Support\Facades\Schema; $columns = Schema::getColumnListing('cart'); $query = DB::table('cart'); $firstColumn = array_shift($columns); $query->where($firstColumn, $field->id); foreach($columns as $column) { $query->orWhere($column, $field->id); } $result = $query->exists();